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..
Bookmarks