This article explains how to use the COUNTIF function in selected cells in Excel 2019, 2016, 2013, 2010, 2007, Excel for Microsoft 365, Excel Online, for Mac, iPad, iPhone, and Android.
How to Use COUNTIF and COUNTIF in Microsoft Excel
In Excel, the syntax of a function refers to the layout of the function and includes the function name, parentheses, and arguments. The syntax for the COUNTIF function is:
The function's arguments tell the function what condition is being tested and what range of data to count when the condition is met.
Follow the steps in this article to create and use the COUNTIF function. In this example, the COUNTIF function counts the number of sales reps with more than 250 orders.
