Formula Help

[rehberger]

Hello,
Would anyone be able to assist me with this formula?
I am trying to average May Swipes below only if the forecast is greater 30,000.


[TABLE="width: 209"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Forecast [/TD]
[TD]May Swipes[/TD]
[/TR]
[TR]
[TD]17825[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]19113[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]37305[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]33120[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]41479[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]14983[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD]40009[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]18397[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]24482[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]21654[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]13786[/TD]
[TD]13[/TD]
[/TR]
</tbody>[/TABLE]



Thanks!

 

[Marcelo Branco]

Try

=AVERAGEIF(A2:A12,">30000",B2:B12)

M.

 

[rehberger]

Awesome, thank you!

 

[Marcelo Branco]

You are welcome and thanks for the feedback.

M.