+ Reply to Thread
Results 1 to 3 of 3

setting up a workbook for adding totals together for a week and monthly basis

  1. #1
    Registered User
    Join Date
    02-08-2012
    Location
    kent, england
    MS-Off Ver
    Excel 2003
    Posts
    21

    setting up a workbook for adding totals together for a week and monthly basis

    hi people. Im trying to be a bit more organised within my department. every day I type my cutting logs to record what, when and how much I foam I cut and would like to try to impliment something that could see what type of foam I used on what day and how much I used to use the data sort it out into date and type put the info into a weekly foam used book and then progress onto a monthy usage of foam. Im pritty new to this, I can do simple things lke set up to add etc etc but thats as far as I know. Ive uploaded my book to help show what I would like to do. Any help in te right direction would be very appreciated
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: setting up a workbook for adding totals together for a week and monthly basis

    Hi,

    With tasks like this it's always advisable to enter your data in a simple two dimensional table as I have shown in B:E on the Data sheet. Columns C & D contain drop downs that you can use to pick the Foam types and thicknesses - based on the two small lists in K & M

    Once you have this 2D table it is then a simple matter to use a pivot table to analyse and summarise your data. Google Excel Pivot tables and you'll discover lots of detailed explanations and youtube videos.

    Hope this helps
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: setting up a workbook for adding totals together for a week and monthly basis

    Pl see the attached file.You can drag down formulas.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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