Purpose: Each week I forecast the next three months on a separate tab. Each week I summarize each month's totals on a summary tab
Objective: To automatically update the Summary Sheet with weekly totals from each tab by matching vertical and horizontal criteria.
Current formula(on summary sheet): =SUMIFS(INDIRECT(C$3&"!$I:$I"),INDIRECT(C$3&"!$A:$A"),Summary!$A7,INDIRECT(C$3&"!$C:$C"),Summary!$B7)
With this I have i have matched tabname, region, and product. Now I need to match the date and the columname
C3:tabname
Notes:
No tabs need to be summed
The date will not always be in the same column on each monthly tab
The length of the data will vary
Here is a crude set up of summary page. Each column represents a tab with similar information but it may not be in the same column on each sheet
Current Period 1/11/2019
A B C D E
tabname Jan2019Detail Feb2019Detail Mar2019Detail
date 1/11/2019 1/11/2019 1/11/2019
col name Volume Volume Volume
Region Product
North Apples 107.00 174.00 298.00
North Oranges 106.00 173.00 297.00
South Apples 61.00 128.00 252.00
South Oranges 38.00 105.00 229.00
Bookmarks