Thread: Add values on weekly or monthly basis in separate worksheet tabs

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!

Hi cutcreative

Kindly upload a excel file with sample data.