CountIfs Formula - INVALID REF

Erin.24

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.

Screen Shot 2022-06-02 at 4.39.27 PM.png

Dan W

=COUNTIFS({Archived Review Responses_EMPLOYEE Range 3}, Community@row, {Archived Review Responses_EMPLOYEE Range 4},"1")

Your ref } got slid to the end