SUMPRODUCT & COUNTIF

[Guest]

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

 

[Frank Kabel]

Hi
=SUMPRODUCT(--(O28:O500>=0),--(E28:E500="BAG"))

See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Guest]

Thank you, Frank. That works well. I really need to take an Excel course!!

Connie