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 |
#11
|
|||
|
|||
Vlookup Formula Help
Thank you Manas. All the best
-- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "manas" wrote in message ... Thanks Ashish, it was really helpful, appreciate "Ashish Mathur" wrote: Hi, You can use the SUMIF() function =sumif(A1;A5,1,B1:B5) -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "manas" wrote in message ... Is there anyway i can use Vlookup or any other lookup function, looking for a specific value in Column A and the function returns sum of all the values target Column? E.g. Column A has values 1 1 2 1 3 and column B has relative values 23 24 56 34 98 I need to look for '1' in column A and add up respective values in Column B. Output for value 1 should be 81 Any help is appreciated Thanks |
#12
|
|||
|
|||
Vlookup Formula Help
You're welcome, and thanks for the feed-back ... even though my initials are
RD, and the HTH stands for "Hope This Helps"g -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Gmata" wrote in message ... Thanks HTH it worked perfectly! and thanks to you to Pete! |
|
Thread Tools | |
Display Modes | |
|
|