+ Reply to Thread
Results 1 to 2 of 2

base - calculate a YTD average

  1. #1
    Registered User
    Join Date
    02-12-2009
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2000
    Posts
    52

    base - calculate a YTD average

    slightly more complex... but what i want is some kind of base figure sum. i'll explain...

    i've got data for each sales week, 1 thru to 52.

    I want to calculate a YTD average.

    so week 1/week1

    thru to week 1/week 32...
    week 1/week 52 etc

    any formula i can do where it treats week 1 as the base figure, rather than do it all manually. if that makes sense?
    Last edited by VBA Noob; 03-03-2009 at 05:02 AM.

  2. #2
    Forum Contributor
    Join Date
    10-11-2007
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    251

    Re: base - calculate a YTD average

    I am not sure i understand you but here is a test workbook.
    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