Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
If and Sumproduct | Excel Discussion (Misc queries) | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions |