+ Reply to Thread
Results 1 to 3 of 3

averageifs with multiple criteria

  1. #1
    Registered User
    Join Date
    04-19-2017
    Location
    Bangkok
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3

    averageifs with multiple criteria

    Hi there, I was wondering if someone could help me with a formula.

    I have a table similar as below and looking for a formula to get an average of each exchange rate of every month.
    Thanks in advance.

    Date Currencies XXX to USD
    2-Jan-17 JPY 116.32
    2-Jan-17 SGD 1.45
    2-Jan-17 AUD 1.39
    3-Jan-17 JPY 117.07
    3-Jan-17 SGD 1.45
    3-Jan-17 AUD 1.39
    2-Feb-17 JPY 116.32
    2-Feb-17 SGD 1.45
    2-Feb-17 AUD 1.39
    3-Feb-17 JPY 117.07
    3-Feb-17 SGD 1.45
    3-Feb-17 AUD 1.39

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: averageifs with multiple criteria

    Attached is an example of how to calculate the average of each currency.
    Attached Files Attached Files
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: averageifs with multiple criteria

    HI,

    Look this the same with considering the month also

    Punnam
    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)

Similar Threads

  1. AVERAGEIFS with multiple criteria on one range
    By ctsmith84 in forum Excel General
    Replies: 7
    Last Post: 04-23-2020, 11:31 PM
  2. [SOLVED] Macro for AverageIFS, with multiple criteria in the same criteria range
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 05-24-2014, 01:13 AM
  3. [SOLVED] AVERAGEIFS with multiple criteria
    By bibu in forum Excel General
    Replies: 5
    Last Post: 03-22-2014, 03:28 PM
  4. AVERAGEIFS(), with multiple criteria
    By Jkember in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2014, 06:33 PM
  5. AVERAGEIFS Multiple Criteria
    By qhoney in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2014, 03:58 PM
  6. [SOLVED] Averageifs with multiple criteria
    By jbillyo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2013, 04:13 PM
  7. AverageIfs for multiple criteria in different columns
    By HBEE in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2013, 12:21 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