Sum function in excel

Excel SUM Function

SUM function is one of the most used functions in MS Excel. This formula not only adds user define values in a cell but also adds values from different cells. It is used in Excel 2013, 2010, 2007 and other versions of excel with same syntax. Here are few examples to illustrate SUM formula in Excel. We will discuss Excel Subtract, Multiply and Divide at the end of this lesson with examples.

Syntax And Examples:

SUM of multiple cells which are in sequence in a column or row:

=SUM(A1:A7)

SUM of different cells probably not in a sequence:

=SUM(A1,A3,A6)

SUM of both: cells in a sequence and randomly selected cells:

=SUM(A1:A3,A7)

Using SUM formula as a calculator to add user define numbers:

=SUM(5,3,7,3,5)

A
1 6
2 8
3 2
4 7
5 0
6 9
7 1
8 SUM formula here

Extra Tips:

  • If blank cells are added, those will be treated as zero
  • If text cell is added that will also treated as zero
  • While using SUM with a series of cells, check for the hidden columns or rows to prevent mistakes

We would not be adding Subtract, multiply and division formula as a separate lesson because all these work like SUM function. The only thing changes is the used mathematical signs:

Subtract Example:

=A2-A1

Output: 2

Multiply or Product Example:

=A1*A2

Output: 48

Divide Example:

=A1/A3

Output: 3

3 thoughts on “Sum function in excel

  1. The shadow series is much more similar in tone to Ender’s Game and follows Bean and the kids from Battle The first book actually tells the story of Ender’s Game from Bean’s I love the Ender’s Game stories so I’m really curious what rules he’s breaking that irritate Care to share?

  2. so before you give them carob they think, "i am not allowed to that chocolate so i will not eat it, because i possess that kind of cognitive reasoning" is that correct? am i inderstanding you correctly? so when my dog eats a bone, now he thinks its okay to snag a rack of ribs off the counter?

Leave a Reply

Your email address will not be published.

Enjoy the tutorial? Please spread the word :)

Follow by Email
Facebook
Facebook
Google+2k
Google+
http://hirdeshbhardwaj.com/2016/11/08/sum-function-excel/
YouTube39
YouTube