Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMPRODUCT & COUNTIF
I have this formula, which works well:
=COUNTIF(O28:O500,"=0") However, I want to expand it to use SUMPRODUCT, but I can't get my head around it. I want it to only count if "BAG" is in E28:E500. Thank you muchly Connie Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |