Count in tables
 

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

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

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" wrote:

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

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)


"Natalie" wrote in message
...
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" wrote:

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