Help with YEAR TODAY()) in SUMIFS Formula

Hi everyone. I am hoping you can assist me. I am trying to SUMIF the number of assignments we received in the current year, by month and by the service team. My formula is:

=SUMIFS({WORKSHEET COLUMN WITH RANGE}, {WORKSHEET COLUMN WITH RANGE}, =[NAME OF REGION]@row, {COLUMN WITH MONTHS DISPLAYING AS JAN, FEB, MAR, ETC}, =Dec$94)

Everything works great by the month but I want to add in to on sum if current year. I keep getting an Unparseable error when I add the year at the end.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!