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

iPhone X review

How to find a font: Discover the name of a typeface with these apps

The best iPhone for 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)