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",)