SUMIFS INCORRECT ERROR MESSAGE

Sidonia Posteuca

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")

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?