+ Reply to Thread
Results 1 to 2 of 2

Add total number of rows (text) in a column

  1. #1
    rostroncarlyle
    Guest

    Add total number of rows (text) in a column

    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.

  2. #2
    Biff
    Guest

    Re: Add total number of rows (text) in a column

    Hi!

    So, you want to count how many cells have entries on the entire sheet?

    =COUNTA(range)

    Biff

    "rostroncarlyle" <[email protected]> wrote in message
    news:[email protected]...
    >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.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1