Add a 2nd criteria to the sumfunction

[MARKEGANDERSON]

HELLO ALL:

HERE IS MY FORMULA:

=SUMIF(Data!A4:A200,"D1",Data!K4:K200)

I ALSO WANT TO COMBINE THIS ONE


=SUMIF(Data!H4:H200,"RTCH",Data!K4:K200)

 

[T. Valko]

HELLO ALL:

HERE IS MY FORMULA:

=SUMIF(Data!A4:A200,"D1",Data!K4:K200)

I ALSO WANT TO COMBINE THIS ONE


=SUMIF(Data!H4:H200,"RTCH",Data!K4:K200)

Try one of these...

This one will work in any version of Excel:

=SUMPORUDCT(--(Data!A4:A200="D1"),--(Data!H4:H200="RTCH"),Data!K4:K200)

This one will only work in Excel 2007 and later:

=SUMIFS(Data!K4:K200,Data!A4:A200,"D1",Data!H4:H200,"RTCH")

 

[MARKEGANDERSON]

Thank you so much..it worked

 

[T. Valko]

Thank you so much..it worked

You're welcome. Thanks for the feedback!