# How to sum up using Excel; SUM Function explained

October 2, 2022

The Microsoft Excel SUM function returns the sum of values supplied by the user. It is the most popular and widely used function in Excel. The SUM function is categorized under Math and Trigonometry functions. It helps users to perform a quick summation of specific cells in Excel.

As an example, here is a cost estimate for garage construction work. We will sum up the total cost in 8 different Excel methods. Let’s get started.

## Auto SUM is the quickest way to sum up

Select the blank cell (F11) where you want the sum result, and click **Ʃ AutoSum** button in the Home tab ribbon to get the summation result. It is the quickest way, to sum up using Excel.

**Keyboard shortcut: Select the blank cell (F11) where you want the sum result, then press (Alt+=) **

It will also work if you select the cells(F4 to F11) and click **Ʃ AutoSum**.

## SUM up by adding individual Cell

**=SUM(Cell 1, Cell 2, Cell 3,……………Cell n)**

Go to the cell where you want the sum result and type =SUM(F4,F5,F6,F7,F8,F9,F10) and press Enter. You will get the summation result.

You can check the formula from the formula bar.

## SUM up without any formula

This is a little tricky. You can see the summation without using any formula. Select all the cells you want to sum and check the status bar right-bottom corner of your screen; you can see the summation of all selected cells.

## SUM up by adding individual cell

**=SUM(Cell 1+Cell 2+Cell 3,……………Cell n)**

SUM up by adding individual cell also give you a summation of added cells. Go to the cell where you want the sum result and type =SUM(F4+F5+F6+F7+F8+F9+F10) and press Enter. You will get the summation result.

You can check the formula from the formula bar.

## SUM up by Sum Range formula

**=SUM(Cell 1: Cell 8)**

Most of the time, most users use the SUM function in Excel to sum up, a range of cells. To sum up, by sum range formula, go to the cell where you want the sum result, type =SUM(F4:F10), and press Enter. You will get the summation result.

You can check the formula from the formula bar.

## Some other uses of the SUM function

We can perform more actions by using the SUM function. Some of them are described below.

### Sum Entire Column

**=SUM(Column: Column)**

If you want to sum the entire column, go to the cell where you want the sum result, type =SUM(A1:A1), and press Enter. You will get the summation result.

You can check the formula from the formula bar.

### Sum Non-contiguous Cells

Non-contiguous means not next to each other. This method has already been described before, but I want to share it again. If you want to sum non-contiguous cells you can follow this method. You can choose any cell you wish.

**=SUM(Cell 1, Cell 3, Cell 7,Cell n)**

### Sum Largest Numbers

**=SUM(LARGE(array ,k1)+ LARGE(array, k2)); k1 and k2= 1st & 2nd largest number**

This SUM formula adds the largest numbers in a row. For instance, If I want to add the two highest costs of garage cost estimates. It will be like the below screenshot.

Dear learners, I have described all possible ways to the solution of How to sum up using Excel. I hope you already understand what I have instructed above. Please let me know if you have any Excel-related queries in the comment box. I will try my best to give you the correct solution. Thank You.

## 0 Comments