Resolve last question using Sumif and Sumifs Formula

 

Using Sum if Sumifs - Sumif and Sumifs

 

Q1 FIND THE TOTAL BASIC SALARY OF DELHI EMPLOYEES

View Answer

Q2 FIND THE TOTAL BONUS PAID TO GURGAON EMPLOYEES

View Answer

Q3 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES

View Answer

Q4 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES COVERED UNDER ESI?

View Answer

Q5 FIND THE TOTAL NET SALARY OF DELHI EMPLOYEES HAVING BONUS >10000?

View Answer

Q6 FIND THE TOTAL PF OF DELHI EMPLOYEES HAVING BASIC >20000?

View Answer

Q7 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES GROSS >20000?

View Answer

 

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

 

  1. Excel

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 8 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .