Averageif?

[tlindeman]

I have a column of Data, in column DG. What I would like to do is throw out the outliers and average it. In other words I want to averageif the data is between -5 and 5. I have office 2007.

Thank You
Tony

 

[Glory]

You can use an array formula to sieve outliers and take the average of the ultimate sum. You use ctrl+shift+delete to enter array formulas. I read a tutorial about array formulas a while back that literally explained how to do exactly that. Someone will have you answer here shortly. but just be aware that it shouldn't be too hard t otrack down what you need if for any reason your thread goes unanswered.

 

[Glory]

=AVERAGE(IF(A1:A10 < X))

<?XML:NAMESPACE PREFIX = X,B1 /><X,B1:B10))< p>I don't know if you can use the "And" operator in a formula to do this:

=AVERAGE(IF(A1:A10 < X And A1:A10 > <X A1:A10 And>Y))
</X,B1:B10))<>

 

[T. Valko]

I have a column of Data, in column DG. What I would like to do is throw out the outliers and average it. In other words I want to averageif the data is between -5 and 5. I have office 2007.

Thank You
Tony

Try this...

=AVERAGEIFS(DG2:DG20,DG2:DG20,">=-5",DG2:DG20,"<=5")

 

[Glory]

Wow, that's so much more direct.

 

[tlindeman]

Thank you for help, it worked.

 

[T. Valko]

Thank you for help, it worked.

You're welcome. Thanks for the feedback!