Formula to add two columns together that meet the same criteria

04/16/19 Edited 12/09/19

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

  • Paul NewcomePaul 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)

    thinkspi.com

Sign In or Register to comment.