|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 9th, 2009, 05:17 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOK UP AND SUM
I am trying to look through a list on names in one column and values in the
column next. If I have a name that repeats I want to add all the corresponding values from the column next. EG. ABC 11 ZXY 8 GUK 22 ABC 3 ABC 8 ABC Total = 22 Any ideas? 
|
|
#2
September 9th, 2009, 05:27 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
LOOK UP AND SUM
=SUMPRODUCT(--(A1:A5="ABC"),--(B1:B5))
=SUMPRODUCT((A1:A5="ABC")*(B1:B5)) HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "AC" wrote: I am trying to look through a list on names in one column and values in the column next. If I have a name that repeats I want to add all the corresponding values from the column next. EG. ABC 11 ZXY 8 GUK 22 ABC 3 ABC 8 ABC Total = 22 Any ideas?
|
|
#3
September 9th, 2009, 06:16 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
LOOK UP AND SUM
Take a look SUMIF function in help menu
"AC" wrote: I am trying to look through a list on names in one column and values in the column next. If I have a name that repeats I want to add all the corresponding values from the column next. EG. ABC 11 ZXY 8 GUK 22 ABC 3 ABC 8 ABC Total = 22 Any ideas?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
