View Single Post
  #1   Report Post  
Connie Martin
 
Posts: n/a
Default 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