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.

Samsung Galaxy S8 review

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

What’s happening in VR right now: From psychedelic art to combat therapy

Siri not working? Try these troubleshooting fixes