Thread
:
SUMPRODUCT & COUNTIF
View Single Post
#
1
Connie Martin
Posts: n/a
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
Reply With Quote