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!
Bookmarks