CountIfs Formula  INVALID REF
I am attempting to do a COUNTIFS formula with a reference to a different sheet.
This is the formula =COUNTIFS({Archived Review Responses_EMPLOYEE Range 3}, Community@row, {Archived Review Responses_EMPLOYEE Range 4,"1"})
If I use only the first criteria in a formula, which would be:
=COUNTIFS({Archived Review Responses_EMPLOYEE Range 3}, Community@row)
the formula seems to work fine.
But when I use the first formula I listed (with 2 criterion) it spits back the error "INVALID REF" and it says I need to edit the first reference. If the first reference is working in shorter formula, why won't it work in the longer formula?
Screenshot is attached of my sheet.
Answers

=COUNTIFS({Archived Review Responses_EMPLOYEE Range 3}, Community@row, {Archived Review Responses_EMPLOYEE Range 4},"1")
Your ref } got slid to the end
Help Article Resources
Categories
Check out the Formula Handbook template!