microsoft excel courses in london - Counting items in columns.

The UK's most regular instructor-led training courses.
Training information: microsoft excel courses in london · Microsoft excel training · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Counting items in columns.

Stuart has attended:
Excel Advanced course

by - delegate Stuart [4 posts] (2007 Mar 15 Thu, 11:38) Reply

Can you please advise the best way to count the number of items which are listed in a column. ( eg a list of names attending a conference?)
thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

Using COUNTA to count items in columns

by - trainer Rich platinum contributer [711 posts] (2007 Mar 15 Thu, 12:04) Reply

Hi Stuart,

I would use the COUNTA() function.

Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that contain data in a range or array.

So if you have a list of people from cells A1 to H1, the calculation would be =COUNTA(A1:H1)

Good luck.

Regards, Rich

· Tips to Facilitate Printing of Excel worksheets
· A Beginners Guide To Formulas In Excel
· How to Create Better Excel Spreadsheets: Part Four
· How to Create Better Excel Spreadsheets: Part Two
· Reasons Why VBA for Excel Training Fails

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips