SUM Formula with example in MS Excel / Excel SUM Formula

SUM Formula with Example in MS Excel / MS Excel SUM Function / Difference between SUM & SUMIF formula / Function in Microsoft Excel.

In Microsoft Excel SUM Function or Formula is a very useful formula or function. With the help of SUM Formula in MS Excel Excel users can calculate / find the SUM of given Numbers. SUM Formula works in all MS Excel Versions like MS Office 2003, 2007, 2010 etc. Here we use SUM Formula with Example.

The SUM formula does exactly what you would expect or want. SUM formula allows you to add 2 or more numbers together very quickly and in a very simple way. You can use cell references (Give values from cells) as well in SUM formula.

What is the SUM Formula in MS Excel?

Formula:- =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5

Now here we add two numbers and numbers with cell reference in excel. You can use Excel as a calculator for mathematical functions. SUM is an example of mathematical functions.
Lets say you have two values and want to add both the values just type =SUM(value1, value2, .......valueN) and you will get the summation of the values / numbers. Instead of entering values or numbers in the formula you can also give cell references if you have data in your Excel Sheet / Table cells and you want to add those numbers / values.

Excel SUM Formula with Example

Instead of typing SUM Formula you can simply adding two or more values by putting + sign between two or more values in MS Excel worksheet or Excel Table after = equal to sign.

There is a another SUMIF Formula / Function in Excel. SUMIF is little different from SUM.

What is the Difference between SUM & SUMIF formula?

There is little difference between SUM & SUMIF Formula in Excel. In SUM Formula you don't need to give any range or range criteria, it adds simply numbers as given. In SUMIF Formula you can give a specific range, criteria you want. SUMIF formula adds the cells specified by given condition and criteria. SUMIF Formula:- =SUMIF(range, criteria, [sum_range]).

To Know Excel Shortcuts CLICK HERE.