I want to sum the cells above of the current one until an empty cell is found. For instance, in the image below, in the summary row, I want to sum the revenue from the orange cell (the red one) going up until the empty cell. As you can see, some of them are wrong:
Use Ctrl key and up key
- Go to the cell where you want the result.
- press up key
- when cursor moves to the cell above the result cell, keep Ctrl pressed and press up key again - all cells until an empty cell will be selected.
- Hit enter.