Opening the COUNTIFS Function dialog box
Although it is possible to just type the COUNTIFS function and its arguments into a cell in a worksheet, many people find it easier to use the function's dialog box to enter the function.
Tutorial Steps
For help with these instructions, see the image above.
- Click on cell F12 to make it the active cell. This is where we will enter the COUNTIFS function.
- Click on the Formulas tab.
- Choose More Functions > Statistical from the ribbon to open the function drop down list.
- Click on COUNTIFS in the list to bring up the function's dialog box.
The data that we enter into the blank lines in the dialog box will form the arguments of the COUNTIFS function.
As mentioned, these arguments tell the function what criteria we are trying to match and what range of data to search to find these criteria.
