Resolve last question using Sumif and Sumifs Formula
Q1 FIND THE TOTAL BASIC SALARY OF DELHI EMPLOYEES
View Answer=SUMIF(C4:C10,"DELHI",D4:D10)
Answer will be 7000
Q2 FIND THE TOTAL BONUS PAID TO GURGAON EMPLOYEES
View Answer=SUMIF(C4:C10,"GURGAON",F4:F10)
Answer will be 15750
Q3 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES
View Answer=SUMIF(C4:C10,"NOIDA",H4:H10)
Answer will be 68700
Q4 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES COVERED UNDER ESI?
View Answer=SUMIFS(H4:H10,C4:C10,"NOIDA",J4:J10,">0")
Answer will be 22700
Q5 FIND THE TOTAL NET SALARY OF DELHI EMPLOYEES HAVING BONUS >10000?
View Answer=SUMIFS(O4:O10,C4:C10,"delhi",F4:F10,">10000")
Answer will be 91431
Q6 FIND THE TOTAL PF OF DELHI EMPLOYEES HAVING BASIC >20000?
View Answer=SUMIFS(I4:I10,C4:C10,"DELHI",D4:D10,">20000")
Answer will be 10800
Q7 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES GROSS >20000?
View Answer=SUMIFS(H4:H10,C4:C10,"NOIDA",H4:H10,">20000")
Answer will be 46000
Download and try
Formula of Sumif
=sumif(Select range,"Write Criteria",Select Range whose sum required)
Note:-
If there are more than one criteria,we should use SUMIFS
Formula of Sumifs
=sumifs(Select Range whose sum required,Select range 1,"Write Criteria 1,Select range 2,"Write Criteria 2",)
