Forum Discussion
How to exclude cells in a column from Sum function in excel (using Ctrl)?
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.
