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. 

 

Paul Newcome

You would need to use a SUMIFS for each range and add them together.

 

=SUMIFS({Jobs Data Report as of 4.12.19 Range 4}, {Jobs Data Report as of 4.12.19 Range 2}, @cell = [Job Number]4)

+

SUMIFS({Jobs Data Report as of 4.12.19 Range 5}, {Jobs Data Report as of 4.12.19 Range 2}, @cell = [Job Number]4)