COUNTIFS Error

Charles Mautz

I am attempting to build a COUNTIFS formula that references another sheetex: =COUNTIFS({Completed Strategy Updates (Goal Primary) Range 1}, 1, {Completed Strategy Updates (Goal Primary) Range 2}, "100%"). I am trying to get all data from "Goal 1" that is less than or equal to 25%, then another that is 26%-50%, etc. The problem I am running into is that anytime I use the % symbol it become unparseable, even though that is how the row I am referencing is set up. Is there a way around this or am I just doing it incorrectly?

Thanks

Bassam Khalil

Hi @Charles Mautz

Hope you are fine, please try the following formula ( for <=25% for example )

=COUNTIFS({Completed Strategy Updates (Goal Primary) Range 1}, 1, {Completed Strategy Updates (Goal Primary) Range 2}, @cell <=0.25)

Bassam Khalil

Hi @Charles Mautz

Hope you are fine, please try the following formula ( for <=25% for example )

=COUNTIFS({Completed Strategy Updates (Goal Primary) Range 1}, 1, {Completed Strategy Updates (Goal Primary) Range 2}, @cell <=0.25)