TOTAL NUMBER OF ENTRIES

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rostroncarlyle - 16 Dec 2005 01:29 GMT

I have a list of files in an Excelt document that has alpha, numeric and date
columns. I would like to total the number of entries (not cells). Please
advise the formula to do this. I don't mind if I use an alpha column or a
numeric or date column to obtain this total.
I did have a response from Biff (which I can't locate) telling me to use
=COUNTA(range) but I couldn't get this to work. Many thanks.

Reply to this Message

David Billigmeier - 16 Dec 2005 01:37 GMT

Well what determines an "entry" then? My guess would have been every
populated cell as well.

Signature

Regards,
Dave

> I have a list of files in an Excelt document that has alpha, numeric and date
> columns. I would like to total the number of entries (not cells). Please
> advise the formula to do this. I don't mind if I use an alpha column or a
> numeric or date column to obtain this total.
> I did have a response from Biff (which I can't locate) telling me to use
> =COUNTA(range) but I couldn't get this to work. Many thanks.

Reply to this Message

Biff - 16 Dec 2005 01:44 GMT

Hi!

=COUNTA(range)

Range is the range of cells that you want to include in the count. Such as:

=COUNTA(A1:A100)

Or

=COUNTA(A1:G1000)

COUNTA will count both text and numeric entries.

Biff

>I have a list of files in an Excelt document that has alpha, numeric and
>date
[quoted text clipped - 5 lines]
> I did have a response from Biff (which I can't locate) telling me to use
> =COUNTA(range) but I couldn't get this to work. Many thanks.

Reply to this Message

rostroncarlyle - 16 Dec 2005 02:43 GMT

Biff

Forgive my stupidity, but do I enter the formula on the blank line
immediately following the last entry, please? Yes, the entries list files
on hand and their current situation. I actually wrote =COUNTA(A3:A114) as
the formula but nothing happened.

Many thanks for your assistance.

> Hi!
>
[quoted text clipped - 21 lines]
> > I did have a response from Biff (which I can't locate) telling me to use
> > =COUNTA(range) but I couldn't get this to work. Many thanks.

Reply to this Message

Biff - 16 Dec 2005 03:04 GMT

Hi!

>do I enter the formula on the blank line
>immediately following the last entry, please?

You can enter the formula anywhere you want *EXCEPT* within the range that
the formula is counting. The bottom of a column of data is the typical place
most people put their formulas.

> I actually wrote =COUNTA(A3:A114) as
> the formula but nothing happened.

Explain *EXACTLY* what that means.

After you typed that in and hit ENTER, what is being displayed in the cell?

Biff

> Biff
>
[quoted text clipped - 35 lines]
>> > use
>> > =COUNTA(range) but I couldn't get this to work. Many thanks.

Reply to this Message

Gord Dibben - 16 Dec 2005 17:21 GMT

Yes, you can enter the formula in any blank cell on the worksheet.

"Nothing" means what?

Blank cell? 0 in cell? Error in cell? The formula shows in cell?

If you have any data in A3:A114 you should get a number in the cell in which
you wrote the fomula.

Gord Dibben Excel MVP

>Biff
>
[quoted text clipped - 30 lines]
>> > I did have a response from Biff (which I can't locate) telling me to use
>> > =COUNTA(range) but I couldn't get this to work. Many thanks.

Reply to this Message