That is why using this function is quite time-consuming. However, if you have only ten or twenty rows, you can use this formula to get your job done. Read: How to count Nonblank Cells in Excel.

Excel's INDIRECT function turns a text string ... First, we will use the COUNT function to work out how many games the team ...

In the example below, we want Excel to count the number of characters in each cell in column A by typing the below function ...