Results 1 to 10 of 10

OFFSET - Joined or combined ranges

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2010
    Location
    USA
    MS-Off Ver
    Excel 2000
    Posts
    9

    OFFSET - Joined or combined ranges

    I have ranges such as

    rrr1 = Sheet1!$a$1:$a$10

    rrr2 = Sheet1!$a$21:$a$30

    rrr = range(rrr1,rrr2)

    ppp = offset(rrr,0,1)

    When I do
    sum(rrr1), I get correct answer
    sum(rrr2), I get correct answer
    sum(rrr), I get correct answer

    but, when I do sum(ppp), I don't get a correct answer

    Is there something wrong with the way I am defining ppp ? The offset function does not seem to work if I have a break in the range. The range "ppp" is not getting defined correctly. Please help..
    Last edited by new22excel; 08-23-2010 at 10:52 AM.

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