Hi I would like to summarise my daily sales but cannot get the vertical data on sheet 1, to be displayed horizontally on sheet 2.



On sheet 1, you will find all the core data that will be input.
In columns N and 0 you will see the summation of the shop sales and orders by day.
The start of the week is on Monday so the first Monday of the 2017 financial year will be 10th April 2017.
All I want to do is take the vertical daily sales and orders in sheet 1 and sum them horizontally in sheet 2 - but I cannot do this by copying down so have to do it manually.
Is there a formula that can do this easily starting from 10th April and summing every week for the entire year?

Thanks in advance

Attached Files

Data Query 21st March 2017.xlsx (34.3 KB, 11 views)

You should be able to do the rest yourself.

Attached Files

DataQuery_2.xlsx (39.8 KB, 13 views)

Xor once again you are a star thank you and you will note I have rearranged the date data vertically now so it is easier to analyse.
Have a lovely Spring day!

Please note that next year (2018) you may have to adjust the starting cell for AllNames. Shop1.Income etc.

Note also that I have changed the content of Sheet1!A6:A7, from text strings to real Excel dates (the latter is always to prefer). The formula in cell A2 will always give the date of the first Monday efter April the 6th. In cell A245 you have 31st November 2017. As you know there is no such date, and it will not appear if you copy the formula in A7 down.

Thank you so much I will play with this over the weekend and check all dates!