Offset Formula Question

[jbodel]

Someone helped me a while ago pulling in figures from another tab in a date range. This is the formula that was provided and it worked exactly as I hoped.

=OFFSET(Daily_Inventory_Report_AllBranc!$B$11,(ROW(E1)-1)*31,0)

So it pulls in the dollar amount every 31 rows in column B.

Now I have learned that the provider that supplied this report has entered amounts in incorrect cells, so now I need to add three different cells (so it would be something like B11+B8+B12. Is this possible?

 

[Joe4]

Someone helped me a while ago pulling in figures from another tab in a date range. This is the formula that was provided and it worked exactly as I hoped.

=OFFSET(Daily_Inventory_Report_AllBranc!$B$11,(ROW(E1)-1)*31,0)

So it pulls in the dollar amount every 31 rows in column B.

Now I have learned that the provider that supplied this report has entered amounts in incorrect cells, so now I need to add three different cells (so it would be something like B11+B8+B12. Is this possible?

Can you post the first few iterations, i.e. what are the first few formulas, and what cells should they be going in?