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

Try these:

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

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

HTH,
Elkar


"Steve" wrote:

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

Perfect !!!

Thanks so much,

Steve

"Elkar" wrote:

Try these:

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

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

HTH,
Elkar


"Steve" wrote:

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