SUMIF ?
 

I would like a formula that calculates the sum of the cells in column M where
the cell in column D of that row is blank.

And another where cells in column D and column E of each row are both blank.

I'm pretty sure Excel can do it - I just can't figure it out.
Thanks for your help!

SUMIF ?
 

Assuming data is within rows 2 to 9
these should work fine:
=SUMPRODUCT(--(D2:D9=""),M2:M9)
=SUMPRODUCT((D2:D9="")*(E2:E9=""),M2:M9)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Paul" wrote:
I would like a formula that calculates the sum of the cells in column M where
the cell in column D of that row is blank.

And another where cells in column D and column E of each row are both blank.

I'm pretty sure Excel can do it - I just can't figure it out.
Thanks for your help!

SUMIF ?
 

the first formula returned 0 instead of the correct number
the next formula returned #value! error
I must be doing something wrong...

"Max" wrote:

Assuming data is within rows 2 to 9
these should work fine:
=SUMPRODUCT(--(D2:D9=""),M2:M9)
=SUMPRODUCT((D2:D9="")*(E2:E9=""),M2:M9)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Paul" wrote:
I would like a formula that calculates the sum of the cells in column M where
the cell in column D of that row is blank.

And another where cells in column D and column E of each row are both blank.

I'm pretty sure Excel can do it - I just can't figure it out.
Thanks for your help!

SUMIF ?
 

OK - now I got it!
I put a space in between the " marks.
Thanks so much!!

"Paul" wrote:

the first formula returned 0 instead of the correct number
the next formula returned #value! error
I must be doing something wrong...

"Max" wrote:

Assuming data is within rows 2 to 9
these should work fine:
=SUMPRODUCT(--(D2:D9=""),M2:M9)
=SUMPRODUCT((D2:D9="")*(E2:E9=""),M2:M9)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Paul" wrote:
I would like a formula that calculates the sum of the cells in column M where
the cell in column D of that row is blank.

And another where cells in column D and column E of each row are both blank.

I'm pretty sure Excel can do it - I just can't figure it out.
Thanks for your help!

SUMIF ?
 

Glad you got it working there!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Paul" wrote in message
...
OK - now I got it!
I put a space in between the " marks.
Thanks so much!!