Skip to main content

SUM Function:



 

Summary

The SUM function helping us to add individual values, selected range or mix of them including selected individual cells.

Will learn with multiple examples:

 

Sr. No.

Function Type

Action

Result

Remark

1

Single Column

=SUM(F2:F16)

68995

The function adds the values available in between and including F2 to F16.

2

Single Row

=SUM(E17:F17)

2293445

The function adds the values available in between and including E17 to F17.

3

Multiple Columns

=SUM(E2:E16,F2:F16)

2293445

The function adds the values available in between and including E2 to E16 and F2 to F16.

4

Multiple Rows

=SUM(E2:F2,E3:F3)

4125

The function adds the values available in between and including E2 to F2 and F2 to F3.

 


Purpose

The SUM function helping us to add individual values, selected range or a mix of them including selected individual cells.

 

Arguments & Syntax

 


As given above syntax contain 1 argument, meaning of the same is given below.


Arguments

Meaning

Number

The selected value, selected range or reference of a mix of the same is Number


Maximum 255 numbers/range can be select in a single formula/function.

 

Translation

So now we will start using a sample data table. This table contains Product purchase costing.

SUM function we can use to know the total for the selected range.

The selected range can be values, cells, range, or reference which can be rows, columns, or both.

  Example:1 

Sr. No.

Argument

Selected Range

Result

Remarks for Result

1

Number

=SUM(F2:F16)

68995

Function adds the values available in between and including F2 to F16.

 

Example:2 

Sr. No.

Argument

Selected Range

Result

Remarks for Result

1

Number

=SUM(E17:F17)

2293445

Function adds the values available in between and including E17 to F17.

 

Example:3 

Sr. No.

Argument

Selected Range

Result

Remarks for Result

1

Number

=SUM(E2:E16,F2:F16)

2293445

Function adds the values available in between and including E2 to E16 and F2 to F16.

 

Example:4 

Sr. No.

Argument

Selected Range

Result

Remarks for Result

1

Number

=SUM(E2:F2,E3:F3)

4125

The function adds the values available in between and including E2 to F2 and F2 to F3.

  

Click here to download the excel practice file.

Click here to open ASHVI CITY – Mr. Excel visualizes video basis learning 

sessions on my YouTube channel.

 

Function Return Value

The value is the total of the selected range or reference.

 

Functions Used

= SUM(E2:F2,E3:F3)

 

Evaluation Operator

Meaning

=

Equal To

 

Common Difficulties

 Example for Error:

Sr. No

Function Type

Buy 1st Time

(Column Name J)

Buy 2nd Time

(Column Name K)

Result

Action

1

Individual Cell selected

Five

10

#VALUE!

=J15+K15

2

Range Selected
(Multiple cells selected)

7

Five

7

=SUM(J16:K16)

3

Value in Text Format

5

5

0

0

 

 

ERROR

Meaning of Error

#Value!

When range contain any non-numeric (Text) value and individual cells selected.

When range contain any non-numeric (Text) value and a range (multiple cells at once) selected, that particular cell will be ignored by the function. The example is given above.

#REF

It comes when the selected cell, column, or range is deleted and formula not edited.

Result is zero

The selected range or reference is in text format so need to convert that into numbers or general to use SUM function.

 

Important Notes:

(1) While function can select a maximum of 255 numbers.

(2) Text formatted cells will be ignored by function while addition.

(3) Do edit in function also when deleting any selected cell or range.

  

Are you are having any Question or Comment? Hit me!



Labels:

Comments

Post a Comment

Popular posts from this blog

MATCH Function:

MATCH Function:       Summary The  MATCH  function searches an item in a range of cells and then returns the relative position of that item in the range. For example, if the range is H4:H7 contains the values SONU, PAWAN, HARUN, and RITTULBHAI, then the formula =MATCH("HARUN",$H$4:$H$7,0) returns the number 3 because HARUN is the third item in the range. Trick Tip : You can use the MATCH function to provide a value for the row_num argument of the INDEX function, using this function you don't need to write numbers manually. So, advise you to use this MATCH function with INDEX function, VLOOKUP , HLOOKUP, etc. First will let you know about the purpose and syntax of the same.   Purpose The MATCH function can use to searches an item in a range of cells and then returns the relative position of that item in the range. Arguments & Syntax     As given above syntax contain 3 different arguments, meaning of the ...
1 comment
Read more

Excel - IF Function || IF formula || English article and Hindi Video

Excel IF Function   Summary The IF function can perform a logical test and return one value subject to TRUE and FALSE value placed by you. IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and whatever you want. For example, to avail incentive, branch should do more than 5 crores sell in a month:  =IF(B2>5,"Eligible","Not Eligible") So, IF function provided two results. First for your TRUE comparison and Second for FALSE comparison as an example given above. Open this video to understand IF function with different data: Above Youtube video link:   https://www.youtube.com/watch?v=CQzsydfB_EE   Purpose IF is a conditional function, who helps us to find out a result on the basis of conditions entered by you.   Translation =IF(B2>5,"Eligibile","Not Eligible") If in the above formula value in “B2” is greater than 5, the return value is Eligible. Otherwi...
2 comments
Read more

Excel – VLOOKUP Function along with Hindi Video

VLOOKUP Function: Summary VLOOKUP is one of the most powerful tools in Excel. The VLOOKUP function enables you to look up data corresponding with the row of a lookup value and corresponding column index. It sounds like a very simple thing, and it is. For example, the VLOOKUP function can use the relational data essentials of two separate tables and affix the data from one table to the other table. You can create a simple Excel table that uses VLOOKUP to lookup and present data from one or other tables.   Don’t worry if it’s sound little difficult, by the end of this article, you will be able to teach others about the VLOOKUP.   First will let you know about the purpose and syntax of the same.   Purpose The VLOOKUP function can use the relational data essentials of two separate tables and affix the data from one table to the other table.   Arguments & Syntax   As Syntax given above VLOOKUP  contain 4 different arguments, the ...
2 comments
Read more