Excel Sumif Function
The Excel Sumif Function Returns The Sum Of Cells That
Meet A Single Condition. Criteria Can Be Applied To Dates, Numbers, And Text.
The Sumif Function Used For Calculate Total Of A Criteria From Selected Data In
Ms Excel.
For Example : A Company Have Many Employee On Same Job
Profile And Now We Want To Calculate
Total Salary Expense Job Profile Wise, Here We Have To Use Sumif Function For
Calculate Sum Base On Single Condition.
Syntax : =Sumif
(Range, Criteria, [Sum_Range])
Arguments
Range - Range To Apply
Criteria To.
Criteria - Criteria To
Apply.
Sum_Range
- Range To Sum.
Here You Can See An Image Below In This Image Already
Some Data Filed (Emp Code, Designation Salary ) And Now I Want To Calculate
Total Salary Of A Particular Designation Such As All Manager Salary, All Office
Boy Salary.
Lets Start,
Now We Have To Calculate Total Salary Job Profile
Wise. Formula Apply On These Cells
1 - F1 All Manager Salary
2 - F2 All Accountant Salary
3 - F3 All Office Boy Salary
Calculate All Manager Salary
Arguments
Function : Click On F1 Cell And Type =Sumif(B2:B13,E1,C2:C13)
0 Comments