Count Formulas

Accounts Tax
Excel

#### What are Filters

Filter are small button at top of column

#### Use of Filter

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

Here we will learn how to Count using Filters

#### Assignment

Apply Filters on Table

and Count the following

Q1 COUNT THE NUMBER OF DELHI EMPLOYEES

2

Q2 COUNT THE NUMBER OF NOIDA EMPLOYEES

3

Q3 COUNT THE NUMBER OF EMPLOYEES GETTING BASIC > 20000?

2

Q4 COUNT THE NUMBER OF EMPLOYEES GETTING BONUS < 5000?

3

Q5 COUNT THE NUMBER OF EMPLOYEES PAYING ESI?

3

Q6 COUNT THE NUMBER OF EMPLOYEES WHOSE TDS DEDUCTED?

4

Q7 COUNT THE NUMBER OF EMPLOYEES WHOSE TDS DEDUCTED >1000?

3

Q8 COUNT THE NUMBER OF DELHI EMPLOYEES GETTING BASIC >20000?

1

Q9 COUNT THE NUMBER OF DELHI EMPLOYEES GETTING BONUS <5000?

0

Q10 COUNT THE NUMBER OF DELHI EMPLOYEES GETTING BASIC >20000 AND BONUS <5000?

0

Q11 COUNT THE NUMBER OF NOIDA EMPLOYEES PAYING ESI?

2

Q12 COUNT THE NUMBER OF NOIDA EMPLOYEES PAYING ESI AND GETTING BONUS>2000?

1

How to Use Filters

1.Select Table

2.Click

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

(Shortcut Ctrl Shift L )

Get live Maths 1-on-1 Classs - Class 6 to 12