=SUMPRODUCT(--(A1:A100="Jon")*--(B1:B100="apples"))

If this post helps click Yes
---------------
Jacob Skaria


"Robert" wrote:

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