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?
=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?