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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…