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]

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

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

a​

[/TD]
[TD]

b​

[/TD]
[TD]

c​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

25​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

25​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

15​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

2​

[/TD]
[TD]

20​

[/TD]
[TD]

1​

[/TD]
[/TR]
</tbody>[/TABLE]



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?