+ Reply to Thread
Results 1 to 4 of 4

Formula For Daily, Weekly And Monthly Averages

  1. #1
    Registered User
    Join Date
    11-11-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    33

    Formula For Daily, Weekly And Monthly Averages

    Column B Column S

    11-12-12 $500
    11-12-12 $750
    11-13-12 $100
    11-17-12 $250
    11-28-12 $100

    So there are days with multiple values
    Column B Dates
    Column C values
    Last edited by jrusso; 11-15-2012 at 07:25 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Formula For Daily, Weekly And Monthly Averages

    for the daily average, you can use averageif()
    for the weekly and monthly, add 2 extra helper columns,
    in the 1st, use =WEEKNUM(B1,1), then use the averageif() function based on that
    in the 2nd, use =month(B1), then use the averageif() function based on that

    If you still have a problem, upload a sample workbook and I will walk you through it
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-11-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Formula For Daily, Weekly And Monthly Averages

    Book1.zip

    here is zipped file

    I really do not know what adding helper columns is all about

  4. #4
    Registered User
    Join Date
    11-11-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Formula For Daily, Weekly And Monthly Averages

    Does anyone know how to do this?

    Thanks

+ 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