SUMIFS INCORRECT ERROR MESSAGE

This formula is giving me Incorrect Argument error message. What am I doing wrong?

=SUMIFS({Phase 99 - SQL Data Range 2}, {Phase 99 - SQL Data Range 1}, "118201", {Oregon Metal Fabrication for Portland Range 1}, {Oregon Metal Fabrication for Portland Range 2}, "118201", {Oregon Metal Fabrication for Amazon Range 1}, {Oregon Metal Fabrication for Amazon Range 2}, "118201", {All Subcontractor Prefab Hours Range 1}, {All Subcontractor Prefab Hours Range 2}, "118201")

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Sidonia Posteuca

    Hope you are fine, i think you have a problem with the formula syntax because :

    SUMIFS( range, criterion_range1, criterion1, criterion_range2, criterion2 .....)

    but in your formula i see

    Range = {Phase 99 - SQL Data Range 2}

    criterion_range1={Phase 99 - SQL Data Range 1}

     criterion1= "118201"

    this is ok but after that i don't understand what is this:

    criterion_range2={Oregon Metal Fabrication for Portland Range 1},{Oregon Metal Fabrication for Portland Range 2}

    you added 2 range why?

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!