SUMIF Function in Excel


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)


Calculate All Accountant Salary

Arguments

Function : Click On F2 Cell And Type =Sumif(B2:B13,E2,C2:C13)


Calculate  All Office Boy Salary

Arguments
Function : Click On F2 Cell And Type =Sumif(B2:B13,E3,C2:C13)


SUMIF Function Excel

1 - F1 All Manager Salary

2 - F2 All Accountant  Salary

3 - F3 All Office Boy Salary


 

Download Excel 




Post a Comment

0 Comments