| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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%? |
|
#2
|
|||
|
|||
|
=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%? |
|
#3
|
|||
|
|||
|
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%? |
|
#4
|
|||
|
|||
|
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%? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables - "simple" question | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
| How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) | |||
| count based on two fields - need quickly | Excel Worksheet Functions | |||
Linear Mode
