COUNTIFS formula with year
I'm trying to put together a COUNTIFS formula for my Sheet Summary that will count the number of items that are shown as Completed in the status column along with what year they were completed in. Looking at other discussions, I found this:
=COUNTIFS([NVAP Phase/Status]:[NVAP Phase/Status], "Completed", [NVAP Completed Date]:[NVAP Completed Date], YEAR(@cell) = 2019)
This formula produces an "#INVALID DATA TYPE" error message, which is at least a change from the dreaded "#UNPARSEABLE" that I've been getting so far.
Any help on how to put together a formula that might work here?