Wed 9 Jan 2008, 11:25Delegate Alison said...
Alison has attended:
Excel Advanced course
Excel
How is the easiest way to Count the number of Items in a list which are words. For example if you had a list of Hotels in London and Edinburgh, how can you easily count the london entries, without putting in an extra column with 1 in it?
Thu 10 Jan 2008, 13:55Trainer Amanda said...
RE: Excel
Hi Alison
Thank you for your question.
There is a function called COUNTA which can be used to count text or alpha-numeric entries in a spreadsheet.
So if your list of hotels was in A3:A22, you could enter =counta(A3:A22) and it will tell you how many entries there are in that range.
I hope this helps.
Amanda
