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 » Formulas

	98.1 % recommend us
	More live stats...

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

Training information:

Formulas

Resolved · Low Priority · Version 2010

Reply Wed 20 Jul 2011, 16:54Delegate Beckie said...

Beckie has attended:
Excel Introduction course

Formulas

when doing a 'count' formula it comes up with an error when only selecting once individual cell to include in a range. Is there a way around this?

For upcoming training course dates see: Pricing & availability

Reply Mon 25 Jul 2011, 10:40Trainer Anthony said...

RE: Formulas

Hi Beckie, thanks for your query. That sounds odd. =COUNT(A1) should return 1 if a number is in cell A1. Can you supply a bit more information about what you are trying to count?

Anthony

Reply Mon 25 Jul 2011, 10:52Delegate Beckie said...

RE: Formulas

Hi Anthony

Thanks for getting back to me,

I have a list of names on a spreadsheet where i want a total at the bottom of the number of cells with names in as they are everchanging and i dont want to physcially count it up everytime i want to add a new name/remove one.

I found that if i was totaling multiple names i.e. from A1 to A21 it was fine however my column of totals is broken into department where there may only be 1 name in one of the departments meaning i only want to add 1 to my toal i.e. cell ref A22. Ive done a sort of example below,

Dept 1
name
name
name

Dept 2
name

It doesnt let me include just 1 cell there has to be multiple.

Thanks
Beckie

Reply Mon 25 Jul 2011, 11:18Trainer Anthony said...

RE: Formulas

Hi Beckie. Ah, names! Replace COUNT with COUNTA in your formula. That will count text values rather than numbers which is what I think is causing the problem. Let me know how you get on.

Anthony

Reply Wed 27 Jul 2011, 12:14Delegate Beckie said...

RE: Formulas

Hi Anthony

Thats perfect!

Thanks for your help

Beckie

Excel articles

· How To Use Conditional Formatting In Excel
· How To Take Your Data Out Of The Shade
· How To Create An Excel Formula Using Data From Several Worksheets
· Excel: Survival Of The Fittest
· How Getting Together Is Now Even Easier With Excel

Please browse our web site to find out more about
microsoft.excel.courses.in.london and other Microsoft training courses.

Excel tip:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

View all Excel hints and tips