Sum and Sumif Functions MS Excel

 Sum and Sumif Functions MS Excel

-Dr. Lalit Kumar Setia

We are well aware of the Sum function which makes the total of the figures provided in a cell range in Excel. We need to know about the other Sum Series functions to make our work easier in MS Excel. There are eight formulas associated with the word SUM:

Suppose you are working in a particular organization where products are sold, every day, a lot of categories of products are sold. The Excel software can make the work easier by keeping the record of each category of products sold during the day, week, month, etc.

In ordinary SUM function, it is well known that the cell range numeric values are totaled and it is not required to explain more. For example =SUM(A2:A6) is used to do the same work as we use =A2+A3+A4+A5+A6 for making a total of the cell values. We can use the various cell ranges in the brackets also. For example, two cell ranges can be totaled by using the function: =SUM(A2:A4,C2:C3). 

How to use SUMIF?

Suppose you have data of sales of many companies and many products associated with each company. Merely using the SUM function will add the cell values of the range without applying any condition upon it. But if you want to apply a condition before screening the cell values for summation, then SUMIF is used.

In the above example =SUM(A2:A6) is making the total of cell values of A2 to A6 without applying any condition. Suppose the values are 12,15,20,25,50 in the cells A2 to A6. Now if you want to make a total of values above 20 only what can you do? Here it is required to apply a condition before making a summation. Therefore, SUMIF will be used.

Cell Values
12
15
20
25
50
122	sum(A2:A6)
75	SUMIF(A2:A6,">20")

*Copyright © 2021 Dr. Lalit Kumar. All rights reserved. 

This article is written by Dr. Lalit Kumar Setia; a renowned author and trainer. He completed his Doctorate in Commerce from Kurukshetra University Kurukshetra and MBA in Information Technology from GJU, Hisar. He also wrote two books, 15 research papers, and organized more than 200 Training Courses during his working period since 2006 in Haryana Institute of Public Administration, Gurugram. The article was published on 29th September 2021 and last updated on 29th September 2021. The writer can be contacted on lalitkumarsetia@gmail.com 

More articles of your interest

https://successinexamination.blogspot.com/2021/03/computer-applications-microsoft-windows.html

https://groomthepersonality.blogspot.com/2018/01/how-does-google-adsense-work.html