ExcelBanter - Sum when one cell is blank & another cell is not blank.

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sum when one cell is blank & another cell is not blank. (https://www.excelbanter.com/excel-worksheet-functions/226947-sum-when-one-cell-blank-another-cell-not-blank.html)

Greta

Sum when one cell is blank & another cell is not blank.

I want to sum the values in column D when the value in column C is blank and
the the value in column F is not blank. (I'm using Excel 2003. )

Gary''s Student

Sum when one cell is blank & another cell is not blank.

=SUMPRODUCT((D1:D100)*(C1:C100="")*(F1:F100<""))

adjust to suit.
--
Gary''s Student - gsnu200843

"Greta" wrote:

I want to sum the values in column D when the value in column C is blank and
the the value in column F is not blank. (I'm using Excel 2003. )

Greta

Sum when one cell is blank & another cell is not blank.

Thank you! I've been trying to find the answer for a while & looking 'in all
the wrong places.'

"Greta" wrote:

I want to sum the values in column D when the value in column C is blank and
the the value in column F is not blank. (I'm using Excel 2003. )

All times are GMT +1. The time now is 07:05 PM.