Operation with COUNTIF() function


Let's find how many buildings have length which is more than 400.

COUNTIF() function provides to count cells with according to the  given condition.

 Firstly, you write the range of the list, which you want to count.

 After, you write the criteria to be considered for counting.