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