Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Apr 2009
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Let's say I want to add 60 rows together in cell A1.

    Is there a faster way instead of writing all rows one by one till row 60?

    A1=B1+B2+B3+B4+B5+B6+B7+B8+B9 ........................................till B60

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    This is what you need to insert in A1: =SUM(B1:B60)
    Rui
    -------
    R4

  3. #3
    New Lounger
    Join Date
    Apr 2009
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Rui, thanks.

  4. #4
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    You are welcome .
    Rui
    -------
    R4

Posting Permissions

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