formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

resolvedResolved · Low Priority · Version 2003

Shiona has attended:
Excel Introduction course

Formulas

What is the difference between Count and Count A?

RE: Formulas - Diff between Count and CountA

Dear Shiona

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

The main diffrence between Count and CountA is that Count is used for counting Numerical data whereas CountA is used for counting Text.

It means that, for example, if you were trying to count cells where there were names of depts. Count Function will not work. You'll have to use the CountA function.

Please note that Count or CountA do not count the cells that are left blank!!

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


 

Excel tip:

Deleting cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + -.

View all Excel hints and tips


Server loaded in 0.07 secs.