Hi I have a query that I hope someone can help me with.

I record daily sales by shop as follows and all data needed is in Row 11.

Monday Tuesday
shop1/ shop 2/ shop 3 /shop4 /shop 5 shop1/ shop 2/shop 3/shop4 /shop 5
A11 B11 C11 D11 E11

On a separate worksheet I want to sum the total sales by day and record them as seen below in my summary sheet;

Monday Tuesday Wednesday
Week 1
Week 2
Week 3

However when I try and copy across from A11:E11 by using =sum and then copying across to the next cell in my summary sheet
, all I get is B11:F11 When I really want E12:E16



I would really appreciate if someone could solve this as I've spent hours to no avail!
Thanks in advance

Attached Files

Sample data.xlsx (11.0 KB, 13 views)