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

International Tourist Data

International Tourist Data

Calculate which country recieves the most tourists in each continent.


Regional Sales Data

Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals


Regional Sales Data

Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals