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.

Related Trainings

Most Popular Movies

Most Popular Movies

Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...


Practice: Adding values that meet a single criteria - Part IV

Practice: Adding values that meet a single criteria - Part IV

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.


Salesperson Ratings

Salesperson Ratings

Create a summary of salesperson sales stats with the help of range lookup.