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 » COUNT/COUNTA

	98.1 % recommend us
	More live stats...

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

Training information:

COUNT/COUNTA

Resolved · Low Priority · Version 2003

Reply Fri 17 Apr 2009, 13:55Delegate Gareth said...

Gareth has attended:
Excel VBA Intro Intermediate course
Excel Intermediate course
Excel Advanced course

COUNT/COUNTA

Can someone please explain the difference between count and counta formulas?

Thanks

For upcoming training course dates see: Pricing & availability

Reply Fri 17 Apr 2009, 16:44Trainer Rajeev said...

RE: COUNT/COUNTA

Dear Gareth

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.

Count is used when you are trying to perform calculations on the cells that contain Numbers AND NOT TEXT.

COUNTA is used when the cells contain Text AND NOT numbers.

Count function returns Zero value if you include cells that contain text.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Excel articles

· Customized Financial Excel Courses in London
· Combining Logical Functions In Excel
· Discover The PMT, IPMT And PPMT Functions In Excel
· Excel and Inventory Management
· Want To Get To Grips With The Different SUM Functions In Excel?

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

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