Formula to add two columns together that meet the same criteria

Jason@TQ
Jason@TQ ✭✭
edited 12/09/19 in Formulas and Functions

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!