sumproduct ?

[Guest]

I have the below data in columns G, H & I

G H I
M0-04 052: 9.35
E0-17 052: 26.55
E0-17 052: 27.24
M0-04 055: 16
M0-04 061: 8

I need -- if g:g is M0-04 and h:h is 052, then add up the corresponding i's,
to =9.35
and,
if g:g is E0-17 and h:h is 052, then add up the corresponding i's, to =
53.79. I need more also, but if I could get these two, I should be able to
get the rest.

I've been trying sumproduct, but can't get it to work right. Any help would
be greatly appreciated.

Thanks,

Steve

 

[Guest]

Try these:

=SUMPRODUCT(--(G1:G5="M0-04"),--(H1:H5="052:"),I1:I5)

=SUMPRODUCT(--(G1:G5="E0-17"),--(H1:H5="052:"),I1:I5)

HTH,
Elkar

 

[Guest]

Perfect !!!

Thanks so much,

Steve

Try these:

=SUMPRODUCT(--(G1:G5="M0-04"),--(H1:H5="052:"),I1:I5)

=SUMPRODUCT(--(G1:G5="E0-17"),--(H1:H5="052:"),I1:I5)

HTH,
Elkar