+ Reply to Thread
Results 1 to 3 of 3

calculate weekly volume based on week number

  1. #1
    Registered User
    Join Date
    03-09-2012
    Location
    Solihull, England
    MS-Off Ver
    Excel 2010
    Posts
    36

    calculate weekly volume based on week number

    Hi all,

    I have the following columns:

    Column A: Unique ID (each component has a unique identifier)
    Column B: Occurrence (each row counts an occurrence)
    Column C: Date (each occurence has a date associated with it)
    Column D: Daily Volume (each occurrence and date has a daily volume figure associated with it)
    Column E: Week number (based on date field)

    Please see attached example.

    In my example the weekly volume for week 8 will be '1538'.

    What i am trying to do is: sum the daily volume given for each day and return a value for any particular week number, sound simple right?

    Please help, thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: calculate weekly volume based on week number

    Hello

    Trying to keep it as much simple as i can, in G2 and copy down use this.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You can hide this column if you wish.

    Now in F2 and copy down, use this.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: calculate weekly volume based on week number

    Thank you for the rep.

    As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 09-25-2013, 01:48 PM
  2. [SOLVED] Determine monthly volume from weekly figures where weeks cross over at month end
    By Grimace in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-21-2012, 09:03 PM
  3. Macro - copy weekly data to a week number
    By Dennikim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2008, 10:47 AM
  4. [SOLVED] XCEL 2 calculate week or bi-weekly accel. mortgage payment
    By commuter in forum Excel General
    Replies: 4
    Last Post: 05-30-2006, 09:15 PM
  5. [SOLVED] Calculating a Date Based on Year, Week Number and Day of the Week
    By amy in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 11:42 AM

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