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