Use Excel Countif function

Use Excel Countif function when you want to see the count of a specific criteria
appear in a selected range.


For Example :

1.How many times does the name "jack"appear in a list of worker names?


2.How many prices higher than 1000 are there in a given price list?



see this video for reference

Using multiple criteria with the “OR” functions

Hi friends this Post is Actually Posted by Mr. Amit Kumar. Specially thanks to him. Mr Amit is our new contributor and he is very happy to share his knowledge with us

The function “OR” is used in a same manner like "AND" function, but its meaning is slightly different.
Instead of checking if all its parts is met (as is the case of the “AND” function), it checks if at least one of the criteria inside it is met. If it is, then the whole “OR” is considered met.

Hence, in the following formula:
=IF(OR(C1>80,D1>80,E1>80) , “Good student” , “Average Student” )

Below here is a Demo Video of OR function with IF.

You all can get more information about if statement from the bellow links.

If Statement Examples

Using Multiple Criteria with And Function

Using multiple criteria with the “AND” functions

Sometimes you need to check more than one criteria with the If statement. You can Use "AND" functions for that.

For example:

Only if the student has grades greater than
80 in HINDI, greater than 80 in English and greater than 80 in ,MATH
only then write “good”, else write “Average”.


Name HINDI ENGLISH MATH REMARKS
A 81 81 81 GOOD
B 80 81 81 AVERAGE

The way to implement such a case is using the “AND” function which will
include all the multiple criteria inside of it.

You can read about more if functions and criteria from the bellow link
IF Statement
OR function with IF
IF function Examples