Results 1 to 9 of 9

How to calculate average by month and year

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    Vancouver, WA
    MS-Off Ver
    2010
    Posts
    29

    How to calculate average by month and year

    I was attempting to get help with this in Chart and Pivot table section, but I may have gotten ahead of myself. I need help with a formula to calculate the average by month and year for each customer on the list. I have enclosed a worksheet. Under Option tab, I began attempting to gather info. I figured out how to calculate the entire total for each customer using



    =IFERROR(AVERAGEIF(RunningLog!B:B,Option!G1,RunningLog!C:C),0)



    But cannot figure out how to break it out by month and year. Any assistance would be greatly appreciated. Thank you.
    Calculate by MMMYYY.xlsx

    MMMYYYAVG.jpg
    Last edited by 1losthuman; 04-01-2015 at 08:59 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Average value for the given month irrespective of any year
    By thilag in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-04-2014, 05:51 AM
  2. [SOLVED] Average if data is in the same month of the same year
    By manofcheese in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2014, 05:05 PM
  3. [SOLVED] I have the day and month but not the Year-need a macro to calculate the Year
    By iplayball in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2013, 01:31 AM
  4. average for month, 1/4 year, year
    By miheec in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2012, 06:34 PM
  5. to calculate this month, this year, last year figure
    By mingali in forum Excel General
    Replies: 7
    Last Post: 08-07-2010, 03:22 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