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

counta

ResolvedVersion 2003

Stephanie has attended:
Excel Introduction course

CountA

How do you use Count A

RE: CountA

Hi Stephanie.

Thanks for the question and welcome to the forum.

It's quite easy to use CountA.

You just go to the cell you want to put the answer in, type:
=COUNTA(
and then select the column/rows you want to include in the formula. For example A1-A7.
Then type the closing bracket:
)
And press enter.

It's a useful function function that counts up the number of cells containing data, either numbers or labels, in your selected range.

I hope this answers your question. We look forward to answering any more you may have.

Kind regards,
Rich

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Switch between workbooks ni EXCEL.

use Alt-TAB to switch between workbooks.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.