I want to do formula for an average of L12W Sales without any outliers or peaks or bottom. What would the formula be?
For example, here is last 12 weeks sales.
I want it to average the sales in between 45-75 not taking 2,3,150,250 into the average.
[TABLE="width: 500"]
<tbody>[TR]
[TD]50[/TD]
[TD]2[/TD]
[TD]150[/TD]
[TD]75[/TD]
[TD]45[/TD]
[TD]48[/TD]
[TD]65[/TD]
[TD]52[/TD]
[TD]250[/TD]
[TD]55[/TD]
[TD]3[/TD]
[TD]60[/TD]
[/TR]
</tbody>[/TABLE]
thank you,
For example, here is last 12 weeks sales.
I want it to average the sales in between 45-75 not taking 2,3,150,250 into the average.
[TABLE="width: 500"]
<tbody>[TR]
[TD]50[/TD]
[TD]2[/TD]
[TD]150[/TD]
[TD]75[/TD]
[TD]45[/TD]
[TD]48[/TD]
[TD]65[/TD]
[TD]52[/TD]
[TD]250[/TD]
[TD]55[/TD]
[TD]3[/TD]
[TD]60[/TD]
[/TR]
</tbody>[/TABLE]
thank you,