Difficulty with sumifs formula


I was hoping someone could help me. Having difficulty getting my sumifs formula to work.

I am trying to sum a total if a project is closed and for projects closed within the year 2020. Currently this is the formula I am trying to use (tried different variations to no success):

=SUMIFS({Cyndy Brewczak Project List Range 1}, "Closed", {Cyndy Brewczak Project List Range 2}, AND(@cell >= DATE(2020, 1, 1), @cell <= DATE(2020, 12, 31), {Cyndy Brewczak Project List Range 4})))

Project list 4 in the example above is the column that has the totals that need to be summed.

If anyone can provide some insight or helpful hints it'll be greatly appreciated.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!