excelimageHave you ever wanted to know how many entries were in a list in Excel? You can use the Count functions to give you an accurate number.

The first Count function only counts cells that contain numbers. Will ignore any cell that has text in it

=COUNT(A2:A24)

The second Count function will count cells that have anything in them, numbers, text, formulas

=COUNTA(A2:A24)

The third Count function counts blank cells, very handy if you have a list with gaps in it.

=COUNTBLANK(A2:A24)

Now you can easily get accurate numbers. Enjoy!