Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif a corresponding value is not equal to zero or blank
I want to use countif to count the number of entries in a big list. However,
I want to count the number of times an entry appears but only if the column next to it is not equal to zero of blank. E.g. Qty Apple 1 Banana 0 Apple 0 Apple 6 Banana 3 I would like to be able to use countif to sum up the number of times apple appears when the qty is greater than zero (or blank) so in this case it would be 2, not 3 as one entry is 0. Can you help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif a corresponding value is not equal to zero or blank
=SUMPRODUCT((A1:A100="Apple")*(B1:B1000))
"raphiel2063" wrote: I want to use countif to count the number of entries in a big list. However, I want to count the number of times an entry appears but only if the column next to it is not equal to zero of blank. E.g. Qty Apple 1 Banana 0 Apple 0 Apple 6 Banana 3 I would like to be able to use countif to sum up the number of times apple appears when the qty is greater than zero (or blank) so in this case it would be 2, not 3 as one entry is 0. Can you help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif does not equal | Excel Worksheet Functions | |||
CountIf not Equal to. | Excel Discussion (Misc queries) | |||
Why does blank text equal 0? | Excel Worksheet Functions | |||
I don't want blank tp equal zero | Excel Discussion (Misc queries) | |||
Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) |