Counting completed cells in Excel

  MalcSP 10:05 28 Jan 2003
Locked

I am trying todo a spread sheet where I need to total the number of cells in a 100 cell column that have been completed ie text has been entered. Is there a way?

  cherria 10:19 28 Jan 2003

=counta(A1:A100)

  MalcSP 10:50 28 Jan 2003

Thanks cherria

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

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone