Excel's COUNT function produces a number of cells containing ... It lets you count cells based on specific text or conditions ...
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.