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

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.1 secs.