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

[DimitriArutinov]

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

[#2]

@DimitriArutinov 

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.