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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 11:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com