Ankit
Ankit

Reputation: 129

Extract Value from Column A and then get the count for certain values from Column B for the value in Column A

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

Answers (1)

YowE3K
YowE3K

Reputation: 23984

As far as I can tell, you are just after the formula

=COUNTIFS(A:A,"Apple",B:B,1)

Upvotes: 3

Related Questions