Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in london - Counting items in columns.

microsoft excel courses in london - Counting items in columns.

ResolvedVersion Standard

Thu 15 Mar 2007, 11:38 Delegate Stuart said...

Stuart has attended:
Excel Advanced course

Counting items in columns.

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

Thu 15 Mar 2007, 12:04 Trainer Rich said...

Using COUNTA to count items in columns

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

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

microsoft excel courses in london - Counting items in columns.

Counting items in columns.

Using COUNTA to count items in columns

Excel articles

Excel tip:

Showing all menu items