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

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.