+ Reply to Thread
Results 1 to 3 of 3

Help with AverageIfs

  1. #1
    Registered User
    Join Date
    11-04-2015
    Location
    US
    MS-Off Ver
    MS2013
    Posts
    2

    Question Help with AverageIfs

    Hi everyone,

    I look for help to average a set of number that are greater than 0 and less than 20.
    In Col. A I have (lets say fruit names) Apples, Oranges, Grapes, Peaches. They keep repeating say A1:A20.
    In Col. B I have a number value 0-50. B1:B20 -
    In Col. C (C1= Apple, C2=Oranges, C3= Grapes, C4 = Peaches) I only want the averages for these entries,

    So I've used AVERAGEIFS($B$1:$B$20,$A$1:$A$20,$C1,$B$1:$B$20,">0") this formula works, I also want it to look at values in Col. B that are less the 20 (<20).

    I hope you guys can make sense of it.
    Thank you for any and all the help.

    Ish.

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Help with AverageIfs

    Formula: =AVERAGEIFS($B$1:$B$20,$A$1:$A$20,$C1,$B$1:$B$20,">0",$B$1:$B$20,"<20")

  3. #3
    Registered User
    Join Date
    11-04-2015
    Location
    US
    MS-Off Ver
    MS2013
    Posts
    2

    Re: Help with AverageIfs

    I knew it was something easy. Thank you very much Josephteh

+ 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
    By afpemi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2021, 05:12 PM
  2. [SOLVED] Averageifs
    By Pjcan1 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-02-2019, 01:28 PM
  3. Averageifs help
    By parbynat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-01-2018, 05:50 AM
  4. Averageifs Help.
    By Thehomegroup in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2017, 12:13 AM
  5. Averageifs
    By Tim Bos in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-26-2015, 09:41 AM
  6. [SOLVED] MIN and MAX like an AVERAGEIFS?
    By superchill435 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-10-2012, 09:06 AM
  7. AverageIfs
    By DMAN11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-07-2010, 05:31 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1