#16
|
|||
|
|||
See the attached. |
#17
|
|||
|
|||
Hi Xor this is exactly what I was after and thanks for educating me re name manager. As this works what is the best way for me to get the live data in - should I save as and add in the real data in the data sheet? I obviously do not want to mess with the formulas. One additional question is there an easy way to incrementally add the days to the merged data in cells 09-EE9 so that Monday follows Tuesday etc without having to manually copy and paste? thanks for all your help thus far - really appreciated
|
#18
|
|||
|
|||
You wrote:
As this works what is the best way for me to get the live data in - should I save as and add in the real data in the data sheet? I see no reason to save as add in. See my comments in sheet Data. |
#19
|
|||
|
|||
Thank you Xor I will start adding in the live data and let you know when all complete - excellent work regardless have a great weekend
|
#20
|
|||
|
|||
Happy new year Xor and I just wanted to let you know that I have added in all data to the data sheet and the weekly summation works fine. Can you let me know if, going forwards, I am able to delete or add rows to the data sheet or will this interfere with the rearrange sheet you created?
Thank you |
#21
|
|||
|
|||
Which rows do you want to delete?
|
#22
|
|||
|
|||
Summing Vertical Data Horizontally
Hi further to the advice of Xor last year I have rearranged my data vertically however still have a problem with summing the total sales weekly and I would really appreciate some help.
Please see the attached updated spreadsheet. 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 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 |
Tags |
columns, formula, sum |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Summing Durations between 2 locations? | Avsfan3319 | Excel | 1 | 03-06-2016 05:40 PM |
Challenge summing time (mm:ss) values? | Mr Davo | Excel | 3 | 12-17-2014 10:41 AM |
New Cost columns are not summing up. | elvanaguven | Project | 3 | 11-08-2014 02:28 PM |
Why does not summing up from different sheet work? | Kh1978 | Excel | 1 | 05-14-2014 02:22 AM |
SUMMING TWO COLUMNS | LOGISTICS1 | Excel | 1 | 04-18-2006 06:00 AM |