|
|
#10
12-08-2016, 09:10 AM
|
|||
|
|||
1. Can you accept that data (as in Data Sheet) are arranged another way than shown (vertically instead of horizontally).
2. What kind of dates (in Data Sheet row 11) are we talking about. I wonder which year was 1 January a Monday. Can we use real Excel dates instead of strings like "Monday January 1st. 3. For how many weeks will there be data. 4. Will it be necessary to distinguish between shops (It doesn't seem so in your Summary Sheet). 5. Can you accept a pivot table or must it be a formula solution? 
|
| 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 |
Windows 10 
Office 2016
Threaded Mode