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:

enter image description here

1 Answer 1


Use Ctrl key and up key

  1. Go to the cell where you want the result.
  2. Type = sum(
  3. press up key
  4. 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.
  5. Hit enter.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.