I have a set of SUMIF formula like:
=SUMIFS('Worksheet1'!W:W,'Worksheet1'!AD:AD,Cost!B2,'Worksheet1'!AB:AB,Cost!B3)
But now want to insert criterias on sum_range, let's say
Size > 20, use 'Worksheet1'!Z:Z
<size<=20, use="" 'worksheet1'!y:y
<size<=20, use="" 'worksheet1'!y:y
Size greater than 10 but less than 20, use 'Worksheet1'!Y:Y
the rest, 'Worksheet1'!W:W
How can I modify it to incorporate above criterias on sum_range? As just insert IF functions, too many arguments encountered.</size<=20,></size<=20,>
=SUMIFS('Worksheet1'!W:W,'Worksheet1'!AD:AD,Cost!B2,'Worksheet1'!AB:AB,Cost!B3)
But now want to insert criterias on sum_range, let's say
Size > 20, use 'Worksheet1'!Z:Z
<size<=20, use="" 'worksheet1'!y:y
<size<=20, use="" 'worksheet1'!y:y
Size greater than 10 but less than 20, use 'Worksheet1'!Y:Y
the rest, 'Worksheet1'!W:W
How can I modify it to incorporate above criterias on sum_range? As just insert IF functions, too many arguments encountered.</size<=20,></size<=20,>