I have a sheet that shows the weekly sales (Columns A B & C)
By entering the criteria in E3 and E4 it will select and display the individual weekly total in G3. If you enter "ALL" in F3 it will display the sum of all values in coumn C that correspond to the Year in E3.
This enables me to now show individual weeks or Calendar year totals
MY PROBLEM
I want to display Financial year totals that can cross from one year to the next (in reality this is Week >31 in year 2001 to week 31 in 2002)
I have given names to the corresponding ranges in Column A ie year2001, 2002. But I cant seem to make it happen
Anyone any ideas ?????
By entering the criteria in E3 and E4 it will select and display the individual weekly total in G3. If you enter "ALL" in F3 it will display the sum of all values in coumn C that correspond to the Year in E3.
This enables me to now show individual weeks or Calendar year totals
MY PROBLEM
I want to display Financial year totals that can cross from one year to the next (in reality this is Week >31 in year 2001 to week 31 in 2002)
I have given names to the corresponding ranges in Column A ie year2001, 2002. But I cant seem to make it happen
Anyone any ideas ?????
Sales.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | DATA | SELECTION | |||||||
2 | Year | Week | Sales | Year | Week | Sales | |||
3 | 2001 | 51 | 10000 | 2001 | all | 21000 | |||
4 | 2001 | 52 | 11000 | ||||||
5 | 2002 | 1 | 8000 | ||||||
6 | 2002 | 2 | 9000 | ||||||
7 | |||||||||
8 | Thisisanextractfromamuchlargersheet | ||||||||
9 | |||||||||
Sheet1 |