- Excel Tutorial
- Excel Introduction
- Excel Addition(+)
- Excel Subtraction(-)
- Multiplication(*)
- Excel Division(/)
- Excel IF Function
- Excel SUMIF
- Count & CountIF
- Excel IFerror
- Excel Pivot Table
- Move Pivot Tables
- Excel Drop-Down list
- Conditional Formatting
- Excel Hyperlink
- Excel Vlookup
- Excel Hlookup
- Excel Protect Sheet
- Excel Macros
- Excel Insert Images
- Excel Concatenate
- Excel Text To Column
- Remove Duplicates
- Excel Cell Formatting
- Group in Excel
- Excel Comments
- Excel Freeze Panes
- Excel Charts
- Print in Excel
- Excel Transpose
- Reminders in Excel
- Reduce Excel File Size
- Percentage in Excel
- Substitute Function

EXCEL FORMULAS Excel Tutorial Excel Introduction Excel Addition(+) Excel Subtraction(-) Multiplication(*) Excel Division(/) Excel IF Function Excel SUMIF Count & CountIF Excel IFerror Excel Pivot Table Move Pivot Tables Excel Drop-Down list Conditional Formatting Excel Hyperlink Excel Vlookup Excel Hlookup Excel Protect Sheet Excel Macros Excel Insert Images Excel Concatenate Excel Text To Column Remove Duplicates Excel Cell Formatting Group in Excel Excel Comments Excel Freeze Panes Excel Charts Print In Excel Excel Transpose Reminders in Excel Reduce Excel File Size Percentage in Excel Substitute Function

SUM Function | Sum Syntax | Sum Range | Sum Multiple Range | Sum Entire Column | Auto Sum in Excel

The SUM function in Excel is used to sum a range of cells. you can sum multiple ranges, individual cell values, or cell references.

The SUM function is a common way to add up cell values in Excel.

There are multiple ways to add the numbers in Excel. we can sum cell numbers using the (+) plus sign.

if we use (+) plus sign, it will take more time to add numbers one by one manually, but using the SUM function in Excel it is easy to sum the values from a range of cells.

This tutorial gives you a detailed explanation of adding values (SUM) in Excel.

SUM function itself it says that summing (adding values) of values. In the below examples we can see multiple methods of Addition in Excel.

In the below example, we did the total value of the range of cells in Excel using the SUM function.

In this below example, column C Total and column D Total show the same result. in column C, the total contains the SUM function to get the result, and column D adds each cell value individually.

In this below example we have added multiple ranges using the SUM function.

To do the entire column sum, use the SUM function without any cell references. in this example, we used=SUM(A:A) to find the SUM of the entire column.

One easy way to add up values in Excel is AutoSum. for this, select a cell next to numbers you want to SUM then click Autosum. That's All, Excel will do the Addition for you. When you click on AutoSum, Excel automatically enters a formula to sum the numbers.

We have already discussed that Autosum is the easiest way to Sum a Column or Row numbers. and the shortcut key to use AutoSum is ALT + =. let's see the AutoSum Example in Excel.

In the above example, I have selected the cell below the column of numbers and I just used a shortcut key ALT + = to select Autosum.

If you want to select it from Excel Ribbon, go to Home Tab and click on Auto-Sum. then it will automatically show the sum of the columns. in the same way, you can also use Autosum rows.

- How to Separate Texts in Excel?
- How to use the TRANSPOSE Function in Excel?
- Group and Un-Group in Excel.
- How to use Vlookup in Excel?
- How to use Charts in Excel?

Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.

* To Learn Tutorials in a simple Way.

* To Learn Excel basics with downloadable samples.

* To Learn HTML with sample Website code.

* To Learn PowerPoint presentations.

* To Learn MS Word for offical use.