Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-xp-training - Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel-xp-training - Excel

Resolved · Low Priority · Version Standard

Reply 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?

For upcoming training course dates see: Pricing & availability

Reply 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

Reply Wed 16 Jan 2008, 15:40Delegate Alison said...

RE: Excel

Thank you

Excel articles

· How Excel Training Can Improve Your Company's Sales Process
· Some Mouse Click Tips In Excel
· Using Find And Replace In Excel
· How To Split A Stacked Chart In Excel
· How Excel Can Boost Even The Smallest Business

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips