Enter the data into cells C1 to E11 of an Excel worksheet as shown in the image above.
The tutorial instructions do not include formatting steps for the worksheet.
Select cell E12 to make it theactive cell.
This is where the COUNTIF function will be entered.
Select theFormulastab of theribbon.
ChooseMore Functions>Statistical.
SelectCOUNTIFin the list to pop pop the Function Arguments dialog box.
In Excel for Mac, the Function Builder opens.
Thedataentered into the two blank rows in the dialog box form the arguments of the COUNTIF function.
Highlight cellsE3toE9on theworksheetto enter these cell references as the range to be searched by the function.
Specify the Criteria Argument
The Criteriaargumenttells COUNTIF what data it should find in the Range argument.
Place the cursor in theCriteriatext box.
Select cellD12to enter that cell reference.
SelectOKwhen you’re finished.
On a Mac, selectDoneto complete the function.
This is the cell identified in the function as containing the criteria argument.
pop in>250and pressEnter.
The number 4 appears in cell E12.
