+ Reply to Thread
Results 1 to 3 of 3

Add values on weekly or monthly basis in separate worksheet tabs

  1. #1
    Registered User
    Join Date
    07-12-2011
    Location
    Hong Kong, Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    6

    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!

  2. #2
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

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

    Hi cutcreative

    Kindly upload a excel file with sample data.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

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

    A PivotTable would probably be the best answer
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1