Reputation: 129
The table structure that I have right now is as below:
Column A Column B
Apple 1
Apple 2
Apple 1
Orange 1
Orange 2
I am trying to write a formula where, for all the cells with the value of Apple in column A, I get the total count for values in column B equal to 1.
Please help.
Upvotes: 0
Views: 31
Reputation: 23984
As far as I can tell, you are just after the formula
=COUNTIFS(A:A,"Apple",B:B,1)
Upvotes: 3