Excel, counting entries in a column, ignore blanks

  24dragon 12:01 15 May 2003
Locked

Hi - could someone remind me how to do this, please? If I've got a column of 500 lines, but entries on only 350 of them (not consecutive), what formula do I use to count the number of actual entries, ignoring the blanks? So, in this case, I'd want 350 at the bottom.

Thanks.

  Sir Radfordin™ 12:14 15 May 2003

If they are numerical then you can use the COUNT function:

=COUNT(nn:nn)

Where nn is the cell range.

Doesn't work with text though!

  VoG™ 12:21 15 May 2003

Or use

=COUNTA(A1:A500)

which works with text or numbers.

  24dragon 12:27 15 May 2003

Thanks, VoG™, it's text - I forgot to mention that. Exactly what I wanted.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?