Results 1 to 4 of 4

Adding up Rows

This is a discussion on Adding up Rows within the Excel Questions forums, part of the Question Forums category; I am in need of a formula that adds up the no. of rows rather than the data contained in ...

  1. #1
    New Member
    Join Date
    Nov 2003
    Posts
    17

    Default Adding up Rows

    I am in need of a formula that adds up the no. of rows rather than the data contained in them - Is this possible using an autosum or similar?

    Thankyou

    Jamie


  2. #2
    Board Regular
    Join Date
    Jul 2003
    Location
    Manchester (UK)
    Posts
    4,432

    Default

    Hi,

    Do you mean 'COUNTA'?

    HTH


    Alan
    HTH

    Alan

    --------------------------------------------------------
    Vlookup not sufficient? Follow the link for latest version of FuzzyVLookup or RuleLookup .
    Alternatively to compare two worksheets try Compare Two Sheets
    --------------------------------------------------------
    There are 10 kinds of people - those who understand binary and those who don't

  3. #3
    Board Regular Chitosunday's Avatar
    Join Date
    Jul 2003
    Posts
    1,017

    Default

    OR =ROWS("ur range")
    Mr Young at Heart - Learning is like chasing the wind, it's boundless.

  4. #4
    New Member
    Join Date
    Nov 2003
    Posts
    17

    Default Re: Adding up Rows

    Thanks - used the counta function.


Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com