ExcelBanter - SUMPRODUCT

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - SUMPRODUCT (https://www.excelbanter.com/excel-programming/363695-sumproduct.html)

Sean

SUMPRODUCT

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.

Magnivy

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.

All times are GMT +1. The time now is 02:48 AM.