Count totals by week and month from separate worksheet

Morning everyone,

I got quite desperate by now, trying to figure out probably a very trivial thing and am stuck..
Creating a spreadsheet with sales, where the daily sales will add themselves in next workbook tab to weekly and same story in the next one: daily sales will add themselves to monthly.

=SUM command obviously doesnt work, since after creating this simple formula, copying it doesnt move to another 7 days as needed, but instead moves 1 column down and adds 7 next columns and so on. Neither the intelligent fill, with creating 3 columns and trying to fill rest automatically.

I am not very familiar with what tool to use, so I would appreciate any help.

All the days are in vertical manner, forms of payment in horizontal, therefore month of January cash takings are B2:B32, credit card C2:C32 and so on with 10 different fields as forms of payment.

2nd workbook tab is suppose to have weekly summaries and 3rd tab monthly.

I would very simply like to create a formula, that after copying will fill in the weeks or months respectively, simply by changing the data.
I dont need rounding up the numbers or anything alike.

All I need is: 1st sheet: Mon100, Tues150, Weds80, Thurs70, Fri200, Sat300...
...FORMULA..in the week Commencing 03.01 total 900
...copy/paste special in all the formula fields for week commencing 10.01,17.01... to do the same for me:

ADD NUMBERS FROM A RESPECTIVE NEXT 7 FIELDS, NOT JUMP DOWN BY ONE.


Would someone please help>?

Many thanks in advance!

Is 1.01 the date? If it is you should be using a proper date entry.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save