Sum on the basis of multiple creterias

[Veeru]

Hi,

Looking for forumla which will sum mynumbers on the basis of mutiple creteris mentioned in sheet 1 and then sum of YTD n sheet .

Tryng to use sumproduct,can anyoe suggest anything please

Thank you

[p45cal]

=SUMPRODUCT(((A2:A23=A29)+(A2:A23=A30)+(A2:A23=A31))*(B2:B23=B29)*(C2:C23=C29)*D2:O23)

[S.White89]

could you try the =SUMIFS formula?

[Veeru]

Thanks p45cal...and what about if we only want YTD sum only.....@S.White Sumifs whould not work

[p45cal]

=SUMPRODUCT(((A2:A23=A29)+(A2:A23=A30)+(A2:A23=A31))*(B2:B23=B29)*(C2:C23=C29)*OFFSET(D2:O23,0,0,,MATCH(F30,$D$1:$O$1,0)))

or

=SUMPRODUCT(((A2:A23=A29)+(A2:A23=A30)+(A2:A23=A31))*(B2:B23=B29)*(C2:C23=C29)*OFFSET(D2:O23,0,0,,MATCH(TEXT(TODAY(),"mmm"),$D$1:$O$1,0)))

or

=SUMPRODUCT(((A2:A23=A29)+(A2:A23=A30)+(A2:A23=A31))*(B2:B23=B29)*(C2:C23=C29)*$D$2:$D$23:INDEX($D$2:$O$23,0,MATCH(F30,$D$1:$O$1,0)))

or

=SUMPRODUCT(((A2:A23=A29)+(A2:A23=A30)+(A2:A23=A31))*(B2:B23=B29)*(C2:C23=C29)*$D$2:$D$23:INDEX($D$2:$O$23,0,MATCH(TEXT(TODAY(),"mmm"),$D$1:$O$1,0)))