Using the SUMIF


I'm trying to get a sum of a value in a given year and type. I keep getting the same error #incorrect Argument set. This is the formula I have been try to working for me, I sure I'm missing something but can't figure it out.

=SUMIF([Task Completion]:[Task Completion], YEAR(@cell) = 2022, [Job Type]:[Job Type], "Pump Repair", [Project Value]:[Project Value])

Please help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!