so i'm trying to get mroe accurate data out of my reports. I'm looking for the Average of a column excluding anything higher then a certain mark and equaling the column next to it. Not sure if totally possible. Still new to excel

Example.

A B
10 10
15 17
20 21
35 35
40 41
47 47

So say for htis. I want the average of Column A over the A and the Average of B over B. that i have. But over those numbers. I want the Average of Column A excluding anything 35 and over that equals column B. So Average everything but the 35 and 47. ..And the same for Column B. Thanks for any assistance you can provide

Carlos

edit: i'm not stuck on the AverageIf formula if it needs to be changed, i'm all ears..or eyes....