Countifs formula

[Tennisguuy]

I have the following formula in cell AC4

=COUNTIFS(Rates!G8:G455,">1000",Rates!U8:U455,AB4)

The formula works. However when I changed formula to =COUNTIFS(Rates!G8:G455,">1000",Rates!U8:U455,>=AB4) I get an error message.

I tried this =COUNTIFS(Rates!G8:G455,">1000",Rates!U8:U455,">=AB4") but it returns no value and the value is in U8:U455. The value in AC4 will be a number and it could be any number the user inputs.


Is using greater than or equal to not allowed when using a number with a specific cell. It will work if I use COUNTIFS(Rates!G8:G455,">1000",Rates!U8:U455,">=10") or any other number I put in quotes but since the value can change I input the cell.

 

[sandy666]

maybe ">="&AB4

 

[Tennisguuy]

Thanks Sandy that worked perfectly. Appreciate your help

 

[sandy666]

sure

have a nice day