SUMIFS with multiple criteria in multiple columns


Hi -

I'm trying to create a formula that will sum the amount of hours in one column when it meets a certain criteria (type of hours) from another column, but only if they were accrued after a certain date (a third column). No matter what I try I either get an error. Here is the formula I have so far (which is wrong - somewhere!)

=SUMIFS({Status}, "Project Completed", {Hours Saved}, {Date Completed}, >"01/01/ 2020", {Hours Saved})

Any assistance would be greatly appreciated.

Thank you,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!