<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=539359806247306&ev=PageView&noscript=1"/>

 

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

-a-

7000

-ea-

Q2 FIND THE TOTAL BONUS PAID TO GURGAON EMPLOYEES

-a-

15750

-ea-

Q3 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES

-a-

68700

-ea-

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

-a-

22700

-ea-

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

-a-

91431

-ea-

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

-a-

10800

-ea-

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

-a-

46000

-ea-

 

Download Assignment and try

 

  

How to Use Filters

1.Select Table

2.Click

Home --->Sort and Filter--->Filter

(Shortcut Ctrl Shift L )

 

 

 

  1. Accounts Tax
  2. Excel
Ask Download

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 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com.
Jail