SUMPRODUCT & COUNTIF

C

Connie Martin

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
 
C

Connie Martin

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

Connie
 
Top