How to exclude cells in a column from Sum function in excel (using Ctrl)?

Occasional Visitor

For example: Sum(A1:A1000) without A30,A65 and so on using Ctrl button

1 Reply


There is no direct support for this, but you can do the following:

  • Select the range you want to sum, using Shift and/or Ctrl as needed.
  • Click in the name box on the left hand side of the formula bar.
  • Enter a name for the selected range (must be one word, underscores allowed), for example MyRange.
  • Press Enter.
  • Select the cell where you want the sum.
  • Enter the formula =SUM(MyRange) using the name that you created.