Having trouble inserting OFFSET() as variable twice in formula

Hi everyone,

Long time lurker, first time poster. Online Excel 365.

I have several sheets that I am running through to total sections and I want them to be dynamic based on raw data placed in a master list. Here is what I have so far:

Please Login or Register  to view this content.

This works just fine, and the

Please Login or Register  to view this content.

works great as a variable range.

However, instead of hard coding the

Please Login or Register  to view this content.

, I was hoping to apply the same principle that worked for the first variable range.

When trying:

Please Login or Register  to view this content.

so that the

Please Login or Register  to view this content.

just replaces the

Please Login or Register  to view this content.

, I get a reference error.

I must be doing something wrong with the quotes, but have tried in vain different combos and when I plainly type the

Please Login or Register  to view this content.

into a cell, it returns the correct array. Any idea what I am doing wrong? Thank you!

INDIRECT needs the address of the range, not the range itself. I think you can re-arrange your formula like this:

Please Login or Register  to view this content.

But it's tricky without a sample sheet to look at.

WBD

Oh. I guess you also want the second part:

Please Login or Register  to view this content.

WBD