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.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch