Hello
Hope you are all well. Here is the issue and hope someone can give me a hand.
I attached a file for this question.
I have a column with numbers on every cell that belong to a range. Each range is separated by a blank cell. I need a formula I can drag all the way down, to sum all cells starting from the first range, sum up all values until right before an empty cell, get the total, then continue down start summing up the next range, and so on... I can do this by selecting the SUM(b4:b28), but each range could have more or less numbers down so I would have to manually select each range and use this function. The only thing that separates each range is an empty cell.
Hope someone can give me a hand.
Thank you in advance.
Bookmarks