How to Use the Excel COUNTIF & COUNT A Formulas – Advanced Excel Part 2 In this post, we will explore how to use Excel COUNTIF & COUNT A functions.
The Excel COUNTIF function is used to count cells that meet a given criteria. The Excel COUNT function is used to count the number of cells in a range that contain any type of numeric value.
The syntax for both functions are as follows:
=COUNTIF(range, criterion)
=COUNT(range)
—
COUNTIF is a function