Counting completed cells in Excel

  MalcSP 10:05 28 Jan 03
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 03

=counta(A1:A100)

  MalcSP 10:50 28 Jan 03

Thanks cherria

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

VFX Oscar nominees 2017: Discover how the visual effects were created

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…