Count if Value meets or exceeds criteria

[Welsh Mark3]

Month	Value	Desired Result
1	25	2
1	25	2
2	15	1
2	20	1

<tbody>
</tbody>

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