Excel's COUNT function produces a number of cells containing ... It lets you count cells based on specific text or conditions ...
How To Count Unique Values With A Function If you are more comfortable with Microsoft Excel functions ... more intricate if your column contains text entries. If you were to use the above function ...
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.