software

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.

Well what determines an quot;entryquot; then? My guess would have been every
populated cell as well.--
Regards,
Davequot;rostroncarlylequot; wrote:

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

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

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

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; =COUNTA(range)
gt;
gt; Range is the range of cells that you want to include in the count. Such as:
gt;
gt; =COUNTA(A1:A100)
gt;
gt; Or
gt;
gt; =COUNTA(A1:G1000)
gt;
gt; COUNTA will count both text and numeric entries.
gt;
gt; Biff
gt;
gt; quot;rostroncarlylequot; gt; wrote in message
gt; ...
gt; gt;I have a list of files in an Excelt document that has alpha, numeric and
gt; gt;date
gt; gt; columns. I would like to total the number of entries (not cells).
gt; gt; Please
gt; gt; advise the formula to do this. I don't mind if I use an alpha column or
gt; gt; a
gt; gt; numeric or date column to obtain this total.
gt; gt; I did have a response from Biff (which I can't locate) telling me to use
gt; gt; =COUNTA(range) but I couldn't get this to work. Many thanks.
gt;
gt;
gt;

Hi!

gt;do I enter the formula on the blank line
gt;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.

gt; I actually wrote =COUNTA(A3:A114) as
gt; 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

quot;rostroncarlylequot; gt; wrote in message
...
gt; Biff
gt;
gt; Forgive my stupidity, but do I enter the formula on the blank line
gt; immediately following the last entry, please? Yes, the entries list
gt; files
gt; on hand and their current situation. I actually wrote =COUNTA(A3:A114)
gt; as
gt; the formula but nothing happened.
gt;
gt; Many thanks for your assistance.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; =COUNTA(range)
gt;gt;
gt;gt; Range is the range of cells that you want to include in the count. Such
gt;gt; as:
gt;gt;
gt;gt; =COUNTA(A1:A100)
gt;gt;
gt;gt; Or
gt;gt;
gt;gt; =COUNTA(A1:G1000)
gt;gt;
gt;gt; COUNTA will count both text and numeric entries.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;rostroncarlylequot; gt; wrote in
gt;gt; message
gt;gt; ...
gt;gt; gt;I have a list of files in an Excelt document that has alpha, numeric and
gt;gt; gt;date
gt;gt; gt; columns. I would like to total the number of entries (not cells).
gt;gt; gt; Please
gt;gt; gt; advise the formula to do this. I don't mind if I use an alpha column
gt;gt; gt; or
gt;gt; gt; a
gt;gt; gt; numeric or date column to obtain this total.
gt;gt; gt; I did have a response from Biff (which I can't locate) telling me to
gt;gt; gt; use
gt;gt; gt; =COUNTA(range) but I couldn't get this to work. Many thanks.
gt;gt;
gt;gt;
gt;gt;
Yes, you can enter the formula in any blank cell on the worksheet.

quot;Nothingquot; 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

On Thu, 15 Dec 2005 18:43:03 -0800, quot;rostroncarlylequot;
gt; wrote:

gt;Biff
gt;
gt;Forgive my stupidity, but do I enter the formula on the blank line
gt;immediately following the last entry, please? Yes, the entries list files
gt;on hand and their current situation. I actually wrote =COUNTA(A3:A114) as
gt;the formula but nothing happened.
gt;
gt;Many thanks for your assistance.
gt;
gt;quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; =COUNTA(range)
gt;gt;
gt;gt; Range is the range of cells that you want to include in the count. Such as:
gt;gt;
gt;gt; =COUNTA(A1:A100)
gt;gt;
gt;gt; Or
gt;gt;
gt;gt; =COUNTA(A1:G1000)
gt;gt;
gt;gt; COUNTA will count both text and numeric entries.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;rostroncarlylequot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a list of files in an Excelt document that has alpha, numeric and
gt;gt; gt;date
gt;gt; gt; columns. I would like to total the number of entries (not cells).
gt;gt; gt; Please
gt;gt; gt; advise the formula to do this. I don't mind if I use an alpha column or
gt;gt; gt; a
gt;gt; gt; numeric or date column to obtain this total.
gt;gt; gt; I did have a response from Biff (which I can't locate) telling me to use
gt;gt; gt; =COUNTA(range) but I couldn't get this to work. Many thanks.
gt;gt;
gt;gt;
gt;gt;