Count if Value meets or exceeds criteria

[Welsh Mark3]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Value[/TD]
[TD]Desired Result[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]25[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]25[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]15[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]20[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

I am looking to try and create a formula that counts occurances from a given date range >=20
So in month one the result would be 2 in month 2 the result =1

Your help is greatly appreciated

 

[Fluff]

Which column are you trying to sum?

 

[Welsh Mark3]

Which column are you trying to sum?

trying to Sum column I

 

[Fluff]

In that case the last formula you posted will work, but you need the ranges to be the same size.
So change the I:I to be the same size as the other ranges.

 

[Welsh Mark3]

Which column are you trying to sum?

Perfect thanks

 

[Fluff]

You're welcome & thanks for the feedback