=sumproduct(--(A1:A100="Melons"),--(B1:B100=0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Natalie" wrote in message
...
I need to know how to count the number of times 0& appears next to each
item -

Melons 0%
Apples 0%
Melons 0%
Grapes 0%
Melons 10%
Apples 10%
Melons 0%

I need an answer to how many times Melons are 0%?