+ Reply to Thread
Results 1 to 3 of 3

Calculating Monthly Average

  1. 08-20-2021, 01:58 PM #1
    nevernine9
    nevernine9 is offline
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    Microsoft Office 365 Subscription MSO (Version 2310 Build 16.0.1
    Posts
    52

    Exclamation Calculating Monthly Average

    Hello everyone,
    I am calculating monthly average using "averageifs" to find the monthly average.

    I know I'm making some error, but I haven't been able to figure out what it is.

    I have attached a sample sheet.

    Thank you in advance for your kind help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-20-2021, 02:13 PM #2
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: Calculating Monthly Average

    Put Excel dates in column I e.g. 01/01/2011 in I12
    Reply With QuoteRegister To Reply
  3. 08-26-2021, 08:18 AM #3
    nevernine9
    nevernine9 is offline
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    Microsoft Office 365 Subscription MSO (Version 2310 Build 16.0.1
    Posts
    52

    Re: Calculating Monthly Average

    Excellent John, I entered full date and then I change date format to MMM-YYYY.
    Thank You so much for your help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating monthly average in a pivot table of my choosing, not current month we are in.
    By am37 in forum Excel General
    Replies: 1
    Last Post: 03-05-2015, 05:17 PM
  2. Help for calculating monthly average from hourly data
    By udaslelmi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2013, 12:59 PM
  3. Calculating the average but formulas in blank cells are decreasing average!
    By CLid in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-25-2013, 06:12 PM
  4. Calculating a monthly average from weekly data between worksheet
    By Eric18 in forum Excel General
    Replies: 2
    Last Post: 07-31-2012, 02:25 PM
  5. Excel 2007 : Calculating the monthly average using different criterions
    By mikejones21 in forum Excel General
    Replies: 2
    Last Post: 07-20-2012, 01:06 AM
  6. [SOLVED] iferror when calculating historical average of row, return an average of similair row.
    By bauerbach in forum Excel General
    Replies: 5
    Last Post: 06-19-2012, 04:37 PM
  7. Calculating monthly average
    By Rajaa S. in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2008, 09:07 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1