Translate

Showing posts with label SUM Function. Show all posts
Showing posts with label SUM Function. Show all posts

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:

SUMIF FUNCTION

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

Auto_1

Horizontal Responsive1

Popular Posts

LoP_1

Special Offer!

Funny Baba

Free Seminars

Featured post

Vision of PM Narendra Modi

The vision of PM Narendra Modi  -Rashmi Honorable Prime Minister Narendra Modi shared his vision using his monthly radio addresses through ...

Free Notes

Tips to Grow

Earn Money

Popular Posts

Free Download

Tax Saving

Fun in Life

Labels

Managerial Administration Training Course Accounting Financial Management Government Learning Purpose Income Tax Accountant's Duties Accounts Administration Administration Balance Sheet Cash Book Double Entry System Final Accounts Finance Ledgers Skills Trial Balance Efficiency Financial Financial Administration Procurement Advance Tax Compliance of Financial Rules Corruption Deduction Drawing and Disbursing Officers Excel Executive Financial Control Financial Rules Financial Skills Fraud Haryana Haryana Institute of Public Administration Interest on advance tax MS-Excel Management NPS National Pension System PWD Procedures Public Works Department Purchase Tender Terminology e-Procurement 80 CCD (1) 80 CCD (1B) 80 CCD (2) 80EE Accounts Administrator Accrual Accounting Audit Bank Budgeting Business Cash Management Central Vigilance Commission Computer Aided Accounting Operations Contractor Control Control Mechanisms Drawing and Disbursing Officer Duties of DDOs Economic Crimes Entrepreneurship Ethics Evaluation Event FFM Faculty of Financial Management Financial Analysis Financial Procedures Formula Functions of Officer GASAB Government e-Marketplace. HIPA Haryana Roadways Home Loan How How to Evaluate Human Income Tax Return India Information Information Management Infrastructure Leasing and Financial Services Integrated Financial Management Information System Interest Inventory Management Job Lalit Kumar Setia Liquidity Managing Finances Mistakes Module Money Management Morality Office Procedures Officer Officers Online Participation Participatory Financial Administration Pension Precautions Prevention of Mal-practices Public Financial Management Systems Punjab Financial Rules RTI Receipt Expenditure Reconciliation Record Management Regularizing Services Responsibility Retirement Benefits Retirement Planning SUM Function Section 234 (C) Section 24 Software Staff Story System Systematic Solutions TDS Tax Planning Tax Saving Tendering Tier I Tier II Training Needs Analysis Training Programme Training for Accounts Administrators Treasury Values Workshop Wrong deferred payment of advance tax due dates for payment of advance tax e-Billing e-Finance Applications example of computing interest on advance tax

Happy Moments

Learn and Update

Popular Posts

Auto_1

Horizontal Responsive1