COUNTIF function to count the cells in Microsoft Excel

COUNTIF function to count the cells in Microsoft Excel.

BY using COUNTIF functions we can trace the values in a range. Basically, the COUNTIF functions in Microsoft Excel is one of the statistical functions, to trace or count the numbers of cells that meet a criterion. For example, to trace the number of times a particular designation in a customer list.

COUNTIF function to count the cells in Microsoft Excel

In its easiest form, COUNTIF functions saying –

=COUNTIF(where do you want to look? “what do you want to look for?”)

Illustration of COUNTIF function in Microsoft Excel:

=COUNTIF(A1:A9,”Officer”)

Watch our video to get a more clear idea that how to implement COUNTIF functions in the context of real scenario.