Summing across if condition is met

[Mjoza]

Hi.

I have a table with data and column D of the table has dates and some of the cells in that column are blank.

For all the blank cells in column D I would like to get the sum of E through M in one cell.

For example, D5, D7 and D12 have blanks the formula should bring the sum of E5:M2, E7:M7, D12:M12 in cell N1

I hope someone can help.

Thank you in advance.

 

[steve the fish]

Something like:

=SUMPRODUCT(E2:M10*(D2:D10=""))

 

[Mjoza]

That simple

Thank you Steve.