Formula to add two columns together that meet the same criteria

Jason@TQ
✭✭
Hello,
Need some help with a formula, I am trying to add two columns that meet the same criteria from one sheet to total on another sheet.
I have tried Sumif and sumifs formulas but they both comeback with errors
Here is what I need:
On sheet 1 I want to total columnA and columnB on sheet two if they meet (this) criteria.
I have tried this:
=SUMIFS({Jobs Data Report as of 4.12.19 Range 2}, [Job Number]4, {Jobs Data Report as of 4.12.19 Range 4}, [Job Number]4, {Jobs Data Report as of 4.12.19 Range 5})
but it comes back #INCORRECT ARGUMENT.
I need it to add {Jobs Data Report as of 4.12.19 Range 4} and {Jobs Data Report as of 4.12.19 Range 5} if it matches [Job Number]4 into one cell in a different sheet.
Comments
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!