Excel help please

  Taurus 20:29 11 Aug 03
Locked

Please help, I'm sure the solution must be relatively simple but it eludes me. How can I get Excel count the cells in a column that contain text items, the cells that is. For example, the number of names in a list.

Thanks in advance for any help you can give me.

Dave

  xania 21:00 11 Aug 03

I have a simple solution for this - although I'm sure there's a better way.

Firstly, I add an extra column - my counter. Then in the first row I insert the number <1> and in the second I insert the number <2>. I then select both these cells together, move my cursor to the bottom right hand corner and drag down to the end of the list. On releaseing, all the remaining cells in the counter column will be filled. Finally, I select the 'Number of items' cell for calculations and then <Hide> the column

  Taurus 21:09 11 Aug 03

Many thanks xania, but since I posted I've 'RTFM' and found how it works. Just use COUNTA instead of SUm, eg =COUNTA(A1:A100), simple eh? a bit like me. DOH! Thanks for taking the time to respond, much appreciated.

Dave

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…