Yep. Put C4 in place of apple.

Tyro

"doyree" wrote in message
...
Sorry to bother you but is there way to put a cell in place of "apple"?
say... C4 in place of "apple"?
thank you!!


"PCLIVE" wrote:

=SUMPRODUCT(--(A1:A5="APPLE"),--(B1:B5="FRUIT"))

Adjust for other criteria.

HTH,
Paul

--

"doyree" wrote in message
...
Please help me with following!!

A B
APPLE FRUIT
PEACH FRUIT
APPLE FRUIT
APPLE NO FRUIT
PEACH NO FRUIT

I have above list and i would like to get a cell count for
"APPLE" WITH "FRUIT"
"APPLE" WITH "NO FRUIT"
"PEACH" WITH "FRUIT"
"PEACH" WITH "NO FRUIT"

i prefer not using pivot or dcounta

thank you!!!