AverageIf Formula

[acool]

Hi Everyone,
I am currently trying to create an average formula that takes range A:L into consideration. In this formula, I would like to exclude any numbers from my average that do not fall within 60% of the Total Average from June 23-May 24. For example if the average from A2:L2 is 976, I would want to exclude any number from the calculation that is less than 585. I would like only these numbers to be considered in the new adjusted average formula. Any help would be greatly appreciated. Thank You!

 

[Fluff]

Can you post your actual data using the XL2BB add-in. It saves people from having to type it all out.

 

[kweaver]

Could it be this, filled down?

=AVERAGE(FILTER(A2:L2,A2:L2>INT(AVERAGE(A2:L2)*0.6)))

 

[Cubist]

You can also try

=AVERAGEIF(A2:L2,">="&60%*AVERAGE(A2:L2))