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!