Counting text in two different columns

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

I'm trying to create a formula to count text in two different columns for
instance:

Samle work sheet:

A B
Jon apples
Jo apples
Jon grapes
Jon apples
Jo apples
Jon oranges
Eric apples
Jo apples

I want a formula that would show me how many "apples" Jon has. Please help!
Thanks
 
Try this:

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10="apples"))

Better to use cells to hold the criteria:

D1 = Jon
E1 = apples

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1))
 
=SUMPRODUCT(--(A1:A100="Jon")*--(B1:B100="apples"))

If this post helps click Yes
 
Back
Top