Count in tables

[Guest]

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%?

 

[Bob Phillips]

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

--

HTH

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

 

[Guest]

Thanks!

What if I was to change some of the figures to 100% and some to 50%. Can I
change the formula to return anything less than 100%

 

[Bob Phillips]

This only counts the items, not return them

=sum(--(A1:A100="Melons"),--(B1:B100<1))

--

HTH

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