Instead of manually counting how often a certain value or number appears let Excel do the work for you. The INDEX function will display the value of a cell at a given index but the function underneath it actually returns a reference. Add to formula with Kutools for Excel.
Use COUNTIF function to make Excel count words or numbers in any range of cells.
If we want to insert a formula in Excel then we need to get into the edit mode of the cell where we want to apply and then type equal sign. Excel provides a simple way of displaying formulas in the cells instead of the result. Enter cell references with pointing. Excel has a variety of formulas and functions.