sumif / loop

[go14344]

is there a way i can simplify this formula?.. because it will be too long if i have 50 cell to sumifs..

SUMIF(AdditivesCalc!$I:$I,$A3,AdditivesCalc!$K:$K)+
SUMIF(AdditivesCalc!$L:$L,$A3,AdditivesCalc!$N:$N)+
SUMIF(AdditivesCalc!$O:$O,$A3,AdditivesCalc!$Q:$Q)+
SUMIF(AdditivesCalc!$R:$R,$A3,AdditivesCalc!$T:$T)+
SUMIF(AdditivesCalc!$U:$U,$A3,AdditivesCalc!$W:$W)+
SUMIF(AdditivesCalc!$X:$X,$A3,AdditivesCalc!$Z:$Z)+
SUMIF(AdditivesCalc!$AA:$AA,$A3,AdditivesCalc!$AC:$AC)+
SUMIF(AdditivesCalc!$AD:$AD,$A3,AdditivesCalc!$AF:$AF)+
SUMIF(AdditivesCalc!$AG:$AG,$A3,AdditivesCalc!$AI:$AI)+
SUMIF(AdditivesCalc!$AJ:$AJ,$A3,AdditivesCalc!$AL:$AL)+
SUMIF(AdditivesCalc!$AM:$AM,$A3,AdditivesCalc!$AO:$AO)+.....

thank you

 

[Peter_SSs]

It depends on exactly might occur in the columns of interest and the intervening columns (J, M, P etc).
Does this do what you want?

=SUMIF(AdditivesCalc!$I:$AM,$A3,AdditivesCalc!$K:$AO)

If not could we have some (small) sample data from, say, columns I:Q of 'AdditivesCalc', including all the column headings? Link in my signature block below for posting sample data.

 

[go14344]

solve.. thnxs peter

 

[Peter_SSs]

solve.. thnxs peter

Good news. Thanks for letting us know.