Skip to content Skip to main navigation Skip to footer

How to sum up using Excel; SUM Function explained

How to sum up using Excel

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.

sum up a garage construction cost

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.

Auto SUM

SUM up by adding individual Cell

Formula Syntax
=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.

Addition Method SUM

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 without formula

SUM up by adding individual cell

Formula Syntax
=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 using individual cell add

SUM up by Sum Range formula

Formula Syntax
=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.

sum range formula

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

Formula Syntax
=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 entire column

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.

Formula Syntax
=SUM(Cell 1, Cell 3, Cell 7,Cell n)

Sum non contiguous cells

Sum Largest Numbers

Formula Syntax
=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.

largest sum

IMPORTANT NOTE
If you insert any row above/below the sum function sum result may not include that value, if you insert any row middle of function it will automatically included

included middle

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

There are no comments yet

Leave a comment

Your email address will not be published. Required fields are marked *