mystique07
New Member
- Joined
- Mar 30, 2018
- Messages
- 12
I am having a table with 2000 rows and trying to do a COUNTIFS to find how many combinations i have for the below example.
With one criteria it is coming properly but when i add the next criteria it is not working.
also i cannot type "Apple" i need to reference the cell since i have around 1000 different values
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]orange[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]orange[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]grape[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]grape[/TD]
[/TR]
</tbody>[/TABLE]
Apple & Orange - 2
Banana & Grape - 1
With one criteria it is coming properly but when i add the next criteria it is not working.
also i cannot type "Apple" i need to reference the cell since i have around 1000 different values
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]orange[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]orange[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]grape[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]grape[/TD]
[/TR]
</tbody>[/TABLE]
Apple & Orange - 2
Banana & Grape - 1