S
Steve
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
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