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!