Countifs with with percentages

KO_in_Colo · 01/08/19

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 · 01/08/19

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

KO_in_Colo · 01/17/19

Thank-you very much, Mike!

Countifs with with percentages

Comments

Help Article Resources

Categories