What are Filters

Filter are small button at top of column

It is used to analyze individual items in a data (example count/sum etc)

Earlier we learnt how to Count using Filters

Now,we calculate Sum or Total Using filter

 

 

Assignment

Calculate Sum of following using Filters

Conditional Sum Using Filters - 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
  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 .