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]

How about
=COUNTIFS($B$2:$B$7,">"&20,$A$2:$A$7,A2)

 

[MARZIOTULLIO]

	a​	b​	c​
1​	1​	25​	2​
2​	1​	25​	2​
3​	2​	15​	1​
4​	2​	20​	1​

<tbody>
</tbody>

C1=COUNTIFS($A$1:$A$4,$A1,$B$1:$B$4,">=20") copy down

 

[Welsh Mark3]

Thanks both these work

 

[Fluff]

You're welcome & thanks for the feedback

 

[Welsh Mark3]

=COUNTIFS($I$2:$I$2097,">"&20,$N$2:$N$2097,N2)

Is it possible to change this formula so rather than >20, the value is between 20 & 50?

 

[Fluff]

How about
=COUNTIFS($I$2:$I$2097,">20",$I$2:$I$2097,"<50",$N$2:$N$2097,N2)

 

[Welsh Mark3]

Beautiful Thanks

 

[Fluff]

You're welcome & thanks for the feedback

 

[Welsh Mark3]

You're welcome & thanks for the feedback

I am trying to amend this formula =COUNTIFS($I$2:$I$2096,">10000",$I$2:$I$2096,"<25000",$N$2:$N$2096,N2)

to be SUMIF or SUMIFS but am getting the message that i've entered too few arguments for this function ( the formula I used was =SUMIFS($I$2:$I$2096,">10000",$I$2:$I$2096,"<25000",$N$2:$N$2096,N2)

I have also tried =SUMIFS(I:I,$I$2:$I$2096,">10000",$I$2:$I$2096,"<25000",$N$2:$N$2096,N2) but am getting the error #Value !

Are you able to advise?