Instead of Filters,we can also use Countif Formula

 

Formula of Countif

=countif(Select Area,"Write Criteria")

 

Note:-

Criteria here is always in inverted commas "    "

 

 

Assignment

Resolve last question using countif and countifs

Count by Using Countif and Countifs - Count Formulas

Q1 COUNT THE NUMBER OF DELHI EMPLOYEES

View Answer


Q2 COUNT THE NUMBER OF NOIDA EMPLOYEES

View Answer


Q3 COUNT THE NUMBER OF EMPLOYEES GETTING BASIC > 20000?

View Answer


Q4 COUNT THE NUMBER OF EMPLOYEES GETTING BONUS < 5000?

View Answer


Q5 COUNT THE NUMBER OF EMPLOYEES PAYING ESI?

View Answer


Q6 COUNT THE NUMBER OF EMPLOYEES WHOSE TDS DEDUCTED?

View Answer


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

View Answer


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

View Answer


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

View Answer


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

View Answer


Q11 COUNT THE NUMBER OF NOIDA EMPLOYEES PAYING ESI?

View Answer


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

View Answer

 

Download File and Try

 

Note

If there are more than one condition,we use Countifs instead of Countif

Formula of Countifs

=countifs(Select Area 1,"Write Criteria 1",Select Area 2,"Write Criteria 2")

 

DIFFERENCE BETWEEN COUNTIF AND COUNTIFS

COUNTIF COUNTIFS
it is used if there is only one condition It is used if there is 2 or more conditions

Formula of Countif

=countif(Select Area,"Write Criteria")

Formula of Countifs

=countifs(Select Area 1,"Write Criteria 1",Select Area 2,"Write Criteria 2")

 

 

 

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

Ask a doubt
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 13 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.