Excel Functions Tutorials

- Maths Functions in Excel
- ABS Function in Excel
- AGGREGATE Excel Function
- CEILING Excel Function
- COMBIN Excel Function
- COS Excel Function
- DSUM
- EVEN Function in Excel
- EXPONENTIAL Excel Function
- Excel Matrix Multiplication
- Excel Minus Formula
- FLOOR Function in Excel
- Histogram Formula
- INT Excel Function (Integer)
- LN Excel Function
- LOG Excel Function
- Mode in Excel
- ODD Function in Excel
- POWER Function in Excel
- PRODUCT Excel Function
- PRODUCT Formula in Excel
- PI in Excel
- Quotient in Excel
- Running Total in Excel
- RAND Excel Function
- Rand Excel Formula
- RANDBETWEEN in Excel
- MROUND in Excel
- ROUND in Excel
- ROUND Formula in Excel
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- SIGN Excel Function
- SIN Excel Function
- Square Root in Excel (SQRT)
- SUBTOTAL Excel Function
- SUM Function in Excel
- SUM Formula in Excel
- Excel SUM Shortcut
- SUMIF in Excel
- SUMIFS in Excel
- SUMIF Not Blank
- SUMIFS with Dates
- SUMIF Between Two Dates
- Sumif Text in Excel
- SumIf with Multiple Criteria
- SUMPRODUCT Function in Excel
- SUMPRODUCT Formula in Excel
- SUMPRODUCT with Multiple Criteria
- How to Sum Multiple Rows in Excel?
- TAN Excel Function
- TANH in Excel
- Average vs Weighted Average

- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)

Related Courses

**SUM Formula in Excel (Table of Contents)**

## Excel SUM Formula

The Formula of SUM Function in Excel

Suppose we have a data which contains numerical data such as expense or prices are give in the column, and we need the fastest way to calculate the total or sum up expense or amounts, For this **SUM** formula in excel will come into play. Today in this I’ll show you how to aggregate columns in Excel using **SUM** function.

**How to Use SUM Formula in Excel (with Examples)**

Suppose we have a dataset which specifies about the expenses of the person in a month this data contains variable like **Petrol_expense, Food_expense, Grocery_expense, HouseRent_expense, Car_expense.**

It would be a bit difficult to calculate the total expenses in a month manually. So to calculate this we use SUM Formula in excel which will calculate the total within a seconds.

#### #1 – SUM of Excel Column Using 1 Click or in Status Bar

Let us understand this SUM formula in excel with some examples.

Suppose we have the dataset in which we have a different variable like **Product, Quantity, and Prices.**

In this we have to calculate the total prices of all the products, it would be a bit difficult to calculate. So to ease this task we will use Excel sum formula.

Follow the steps to calculate **SUM** in 1 click:

**Step 1 –** Right-click on the **Status Bar **in excel.

4.9 (1,353 ratings)

**Step 2 –** From the **Menu** click on the SUM, after then select the **Price **column, and **SUM** of **Prices** of all the **Products** will be displayed in the status bar.

As we can see that the Aggregate of **Prices** is displayed in **Status Bar.**

#### #2 – Total of Columns Using AutoSum

If you want to aggregate an excel column and keep the result in the table, you can use the AutoSum function. This function will naturally sum up the numbers and will show an aggregate of **Prices** in the column you select.

Let’s explain this by taking the previous example:-

**Step 1 –** Select the cell in which you want to display the results.

**Step 2 – **Click on the** Home tab **and navigate to the Editing Group and click on the AutoSum

When you click on the **AutoSum, SUM** function will be displayed and automatically select all the cells above it for the total as shown above in the figure.

**Step 3**** – **To get the** SUM **press Enter.

This method lets you automatically calculate the sum and kept the results in your table.

#### #3 – Entering SUM Formula Manually

We can also enter the Excel SUM function manually. This would be used if we want to calculate some of the cells in the columns or a selected range of cells.

**Step 1 –** Select the cell in which you want to display the results.

**Step 2 –** Enter the formula SUM()

**Step 3 –** Select the range of cells to sum up and close the braces.

**Step 4 – **Press the Enter result shown below.

NOTE:-We can also select the range manually instead of sequentially.

Follow the steps to select the range manually.

**Step 1 –** Select the cell in which you want to display the results.

**Step 2 – **Enter the formula =SUM()

**Step 3 – **Select the range of cells to sum up and close the braces.

In this case, we have selected **P4, P6, P5**

**Step 4 – **Press Enter the result shown below.

#### #4 – SUM Excel Columns Using Table

If we want to sum the columns of Excel, we can also use the table. This can be done by converting the spreadsheet into **Excel** **Table. **This will make the aggregation of rows and columns easy. It also performs many other operations with the data.

Using the above example the following steps are here.

**Step 1 –** Press the **Ctrl + T** or click on **Insert Tab **and navigate to Table group and click on **Table**.

**Step2 – A table **dialog box will appear.

Select the data for your table or range. In this case, we have selected **$M$2:$P$7**

A new design and Table Tab will appear at the top.

New table design appears.

**Step 3-** To calculate the Total we will select the Checkbox **Total Row** in **Table Tab **and a new row will be added at the bottom of the table i.e.

**Step 4 –** By clicking at the last row, we can also add many other functions like **SUM, COUNT, MAX, MIN.**

In this, we have covered all the possible ways to perform Total of the cells of the column in Excel.

- Entering SUM formula in Excel Manually
- SUM of Excel column using 1 Click or in Status Bar
- Total of Columns using AutoSum
- SUM using Table

**Things to Remember about the SUM Formula in Excel**

- SUM can only be used with numerical data.
- SUM can be used to find the sum of two or more values.

### Recommended Articles

This has been a guide to Excel SUM Formula. Here we discuss how to use SUM formula in excel along with some practical examples and downloadable excel template. You may learn more about excel from the following articles –

- SUM in Excel | Shortcut Keys
- SUMIF With VLOOKUP | Examples
- Examples of SUMIF Between Two Dates in Excel
- Rows and Columns in Excel
- IF Formula Excel
- Max IF Formula in Excel
- VLOOKUP Function with SUM
- Square Root in Excel
- SUMIFS Function in Excel

- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion