| 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 |
|
#2
|
|||
|
|||
|
Hi
=SUMPRODUCT(--(O28:O500=0),--(E28:E500="BAG")) See: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Regards Frank Kabel Frankfurt, Germany "Connie Martin" schrieb im Newsbeitrag ... 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 |
|
#3
|
|||
|
|||
|
Thank you, Frank. That works well. I really need to take an Excel course!!
Connie "Frank Kabel" wrote: Hi =SUMPRODUCT(--(O28:O500=0),--(E28:E500="BAG")) See: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Regards Frank Kabel Frankfurt, Germany "Connie Martin" schrieb im Newsbeitrag ... 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 |
| Reply |
| 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 | |||
Linear Mode
