Opening the COUNTIFS Function dialog box
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.
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.