Countifs with with percentages

KO_in_Colo

What am I doing wrong?  The formula was fine when I did the tower in air dates from today - 12.31.19, but as soon as I tried to add the condition of lease probability being above 49% it doesn't work. Any thoughts are greatly appreciated!

 

 

=COUNTIFS({C. *Ground Lease Tower In Air Date}, >=TODAY(), {C. *Ground Lease Tower In Air Date}, <=DATE(2019, 12, 31),({Ground Lease Probability Column}, >.49))

Mike Dahl

Remove the parenthesis right here: ({Ground Lease Probability Column} and at the end you only need the one ).

KO_in_Colo

Thank-you very much, Mike!