+ Reply to Thread
Results 1 to 4 of 4

Average formula needed to get average data

  1. #1
    Forum Contributor
    Join Date
    09-07-2015
    Location
    indonesia
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 64-bit
    Posts
    171

    Average formula needed to get average data

    Dear Friends,
    I create a data to get average data. data need match name of supplier and month.
    I have attached the data details
    Please advise which formula is suitable for column H3,I3, H4, I4.
    Thank you in advance for your help.


    Regards,
    Wie Wie
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Average formula needed to get average data

    Try the AVERAGEIF(S) function

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Average formula needed to get average data

    Please try at H3 and copy over the table

    =AVERAGEIFS($E$3:$E$13,$A$3:$A$13,$G3,$C$3:$C$13,">="&1&H$1,$C$3:$C$13,"<="&EOMONTH(1&H$1,0))

    You can put &18 after 1&H$1 if you have other specific year.

    =AVERAGEIFS($E$3:$E$13,$A$3:$A$13,$G3,$C$3:$C$13,">="&1&H$1&18,$C$3:$C$13,"<="&EOMONTH(1&H$1&18,0))
    Last edited by Bo_Ry; 10-19-2018 at 03:52 AM.

  4. #4
    Forum Contributor
    Join Date
    09-07-2015
    Location
    indonesia
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 64-bit
    Posts
    171

    Re: Average formula needed to get average data

    Dear Friends,
    That is work. thanks a lot for your help.

    Regards,
    Wie

+ 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. [SOLVED] Formula for calculating a needed average
    By ayoung060581 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-03-2017, 11:12 AM
  2. [SOLVED] Help needed with a Average formula
    By barryc721 in forum Excel General
    Replies: 5
    Last Post: 07-23-2014, 10:47 AM
  3. Formula needed for running average
    By NeroM in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2014, 04:45 AM
  4. Average balance formula needed please
    By fdamore in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2014, 09:37 AM
  5. Formula needed to get average of values
    By szpt9m in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2013, 08:20 AM
  6. Some help needed with an average formula...
    By hello its dean in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2013, 12:31 PM
  7. Specialized average formula needed
    By jman0707 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-14-2009, 02:08 PM

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