I have a document that has entries consisting of text, numbers and dates in
separate columns. I would like to add the number of entries and don't mind
which column I am totalling. There are no conditions. I need to have the
total number of entries noted at the end of the document rather than having
the total number of lines used as a separate column.
Many thanks.
Hi!
So, you want to count how many cells have entries on the entire sheet?
=COUNTA(range)
Biff
quot;rostroncarlylequot; gt; wrote in message
...
gt;I have a document that has entries consisting of text, numbers and dates in
gt; separate columns. I would like to add the number of entries and don't
gt; mind
gt; which column I am totalling. There are no conditions. I need to have
gt; the
gt; total number of entries noted at the end of the document rather than
gt; having
gt; the total number of lines used as a separate column.
gt; Many thanks.
separate columns. I would like to add the number of entries and don't mind
which column I am totalling. There are no conditions. I need to have the
total number of entries noted at the end of the document rather than having
the total number of lines used as a separate column.
Many thanks.
Hi!
So, you want to count how many cells have entries on the entire sheet?
=COUNTA(range)
Biff
quot;rostroncarlylequot; gt; wrote in message
...
gt;I have a document that has entries consisting of text, numbers and dates in
gt; separate columns. I would like to add the number of entries and don't
gt; mind
gt; which column I am totalling. There are no conditions. I need to have
gt; the
gt; total number of entries noted at the end of the document rather than
gt; having
gt; the total number of lines used as a separate column.
gt; Many thanks.
文章標籤
全站熱搜
