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
