I am pretty new to using formulas. I'm working on a dashboard for one of my sheets and I want to show how many escalations a plant has had this year alone. Here is what I have so far:
=COUNTIFS(([Plant]:[Plant], "Changzhou"), IFERROR(YEAR(@cell), 0) = 2019)
I've tried many different variations based on my scouring of this community but I keep getting #unparseable error. Can anyone help me get it right? Thanks!