Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing with identical Vlookup values
Hi all, I am having a issue with Vlookup. I have a table with a number of values which im looking up in a column but a lot of them are the same. I need a formula that can add the ones that are the same and print the value into a cell. Instance- value i want to look up : bbb Item Number# aaa 5 aaa 3 bbb 4 ccc 8 aaa 4 ccc 7 bbb 8 So i want to to lookup bbb and add all instances together to give me : 12 Any help would be appreciated, thx a lot. -- kanuvas ------------------------------------------------------------------------ kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911 View this thread: http://www.excelforum.com/showthread...hreadid=480062 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing with identical Vlookup values
Hi,
Use SUMIF function: Assume Item Number is in column A (a2:a8) and counts in B (b2:b8) then in C1 put "=SUMIF(a2:a8,"bbb",b2:b8)" (without quotation marks). HTH "kanuvas" wrote: Hi all, I am having a issue with Vlookup. I have a table with a number of values which im looking up in a column but a lot of them are the same. I need a formula that can add the ones that are the same and print the value into a cell. Instance- value i want to look up : bbb Item Number# aaa 5 aaa 3 bbb 4 ccc 8 aaa 4 ccc 7 bbb 8 So i want to to lookup bbb and add all instances together to give me : 12 Any help would be appreciated, thx a lot. -- kanuvas ------------------------------------------------------------------------ kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911 View this thread: http://www.excelforum.com/showthread...hreadid=480062 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing with identical Vlookup values
=SUMIF(A1:A7,"bbb",B1:B7)
-- Kind regards, Niek Otten "kanuvas" wrote in message ... Hi all, I am having a issue with Vlookup. I have a table with a number of values which im looking up in a column but a lot of them are the same. I need a formula that can add the ones that are the same and print the value into a cell. Instance- value i want to look up : bbb Item Number# aaa 5 aaa 3 bbb 4 ccc 8 aaa 4 ccc 7 bbb 8 So i want to to lookup bbb and add all instances together to give me : 12 Any help would be appreciated, thx a lot. -- kanuvas ------------------------------------------------------------------------ kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911 View this thread: http://www.excelforum.com/showthread...hreadid=480062 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing with identical Vlookup values
Thx a lot guys -- kanuvas ------------------------------------------------------------------------ kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911 View this thread: http://www.excelforum.com/showthread...hreadid=480062 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count identical values in 2 rows | Excel Worksheet Functions | |||
Using VLOOKUP for returning multiple values and summing them | Excel Worksheet Functions | |||
Add up all numbers in VLOOKUP that has identical lookup value | Excel Worksheet Functions | |||
Looking Up Datas when Key Values are Identical | Excel Worksheet Functions | |||
Lookup of identical values? | Excel Worksheet Functions |