I understand that the offset function enables one to return a range of cells. The formula (offset) uses 5 arguments. The first argument (Reference) seems, to me, to be random. I can literally use any cell in a sheet, so long as I type the correct second (row) and third(col) arguments.
What is the proper starting point (the "reference" argument) ?
If i have numbers (data) in the range (B2:D4) I can sum it all by using =sum(offset(a1, 1, 1, 3, 3)). Or I could use =sum(offset(b2, 0, 0, 3, 3)). Or I could use =sum(offset(e10, -8, -3, 3, 3). Or I could use =sum(offset(z100, -98, -24, 1, 1))
WHAT SHOULD I USE?
They all return the same thing. Even if I use the countA function in place of the last two arguments, for example =sum(offset(a1, 1, 1, countA(Sheet1!$B:$B), countA(Sheet1!$2:$2)))
Please explain the something I am obviously misunderstanding.
Thanks in advance,
donald
Bookmarks