Thread: SUMPRODUCT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Magnivy Magnivy is offline
external usenet poster
 
Posts: 70
Default SUMPRODUCT

Do columns C and E have the text "fill" in rows 15:20, 30:40, 50:200?

"Sean" wrote:

I want to sum column "C15:20,C30:C40,C50:C200" with numbers in it, only if
columns "D" or "E" do not have the text of "fill" or "FILL" in either one.