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.