Using the SUMIF

Doug_aftgp.com

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

Tatiana Kardosova

Hi.

Try following: =SUMIFS([Project Value]:[Project Value], [Task Completion - Year]:[Task Completion - Year], 2022, [Job Type]:[Job Type], "Pump Repair")

Tatiana