Count Ifs giving error

Rochelle_B

I've created the following cross sheet CountIfs formula:

=COUNTIFS({Hutto NA Status}, "Done", {Hutto NA Owner}, [Primary Column]15, {Hutto NA Date}, >TODAY(-7))

Each segment works perfectly on its own but when I combine them, I keep getting an #INCORRECTARGUMENT error. I'm not sure what the issue is.

Appreciate anyone's help!

Rochelle_B

Looks like this was a case of user error - my ranges were in different sheets.