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.

Thanks!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!