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.
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.