COUNTIF with AND or COUNTIFS --> Not sure how to make this work; neither formula I tried is working

Paige Luben

=COUNTIF(AND({2020-2021 Goal, Budget, and Performance Ti Range 2},"Budget",[{2020-2021 Goal, Budget, and Performance Ti Range 1},"Complete"]))

=COUNTIFS(({2020-2021 Goal, Budget, and Performance Ti Range 2},"Budget",[{2020-2021 Goal, Budget, and Performance Ti Range 1},"Complete"]))

David Joyeuse

Hi @Paige Luben

Try this:

=COUNTIFS({2020-2021 Goal, Budget, and Performance Ti Range 2}, "Budget", {2020-2021 Goal, Budget, and Performance Ti Range 1}, "Complete")

Your COUNTIFS formula was correct but you added [ ] around the 2nd range and 2nd criteria and too much ( ) for the COUNTIFS as a whole :) . Hence the UNPARSEABLE you probably got :)

David Joyeuse

Hi @Paige Luben

Try this:

=COUNTIFS({2020-2021 Goal, Budget, and Performance Ti Range 2}, "Budget", {2020-2021 Goal, Budget, and Performance Ti Range 1}, "Complete")

Your COUNTIFS formula was correct but you added [ ] around the 2nd range and 2nd criteria and too much ( ) for the COUNTIFS as a whole :) . Hence the UNPARSEABLE you probably got :)

Paige Luben

@David Joyeuse THANK YOU SOOOO MUCH not only did that work but I really appreciate you explaining what I did wrong. Somehow the parentheses and brackets are literally always my problem.