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
|
|||
|
|||
How to lookup multiple values and summing them up in one cell
I'd like to combine a sumif and vlookup function. Basically I want to lookup
a "Name" in a table and sum up the corresponding grades (multiple cells) in another table. Can anyone help. Thanks |
#2
|
|||
|
|||
Excel can most probably do what you want, however, to get the best advice
from the people here you probably ought to give us abetter idea of how your data is structured and just exactly what you are trying/wanting to do "Amr Abul Laban" wrote: I'd like to combine a sumif and vlookup function. Basically I want to lookup a "Name" in a table and sum up the corresponding grades (multiple cells) in another table. Can anyone help. Thanks |
#3
|
|||
|
|||
You can use a regular Vlookup formula, and instead of returning a value, you
can return a formula (or actually the result thereof).........the formula can be in the second column of your table and actually only the result of the formula will show there....... A1= a B1= =VLOOKUP(A1,G1:H5,2,FALSE) G1=a, G2=b, G3=c, G4=d, G5=e H1= =SUM(I1:K1), and copy down to H5 Then, B1 will return the sum of I1:K1........ hth Vaya con Dios, Chuck, CABGx3 "Amr Abul Laban" Amr Abul wrote in message ... I'd like to combine a sumif and vlookup function. Basically I want to lookup a "Name" in a table and sum up the corresponding grades (multiple cells) in another table. Can anyone help. Thanks |
#4
|
|||
|
|||
Thanks for the quick reply. I just figured it out. Unbelievable how it took
me so long to come up with a simple formula. But thanks again, I didn't imagine that someone would reply this quickly. I will have to use this resource more often. Thank you very much and greetings from Frankfurt am Main. Cheers "Duke Carey" wrote: Excel can most probably do what you want, however, to get the best advice from the people here you probably ought to give us abetter idea of how your data is structured and just exactly what you are trying/wanting to do "Amr Abul Laban" wrote: I'd like to combine a sumif and vlookup function. Basically I want to lookup a "Name" in a table and sum up the corresponding grades (multiple cells) in another table. Can anyone help. Thanks |
#5
|
|||
|
|||
How to lookup multiple values and summing them up in one cell
Could you share how you did it?
John K "Amr Abul Laban" wrote: Thanks for the quick reply. I just figured it out. Unbelievable how it took me so long to come up with a simple formula. But thanks again, I didn't imagine that someone would reply this quickly. I will have to use this resource more often. Thank you very much and greetings from Frankfurt am Main. Cheers "Duke Carey" wrote: Excel can most probably do what you want, however, to get the best advice from the people here you probably ought to give us abetter idea of how your data is structured and just exactly what you are trying/wanting to do "Amr Abul Laban" wrote: I'd like to combine a sumif and vlookup function. Basically I want to lookup a "Name" in a table and sum up the corresponding grades (multiple cells) in another table. Can anyone help. Thanks |
#6
|
|||
|
|||
How to lookup multiple values and summing them up in one cell
What was the exact formular you used to figure this out? That is combining
sumif with a vlookup formular? Thanks. "Amr Abul Laban" wrote: I'd like to combine a sumif and vlookup function. Basically I want to lookup a "Name" in a table and sum up the corresponding grades (multiple cells) in another table. Can anyone help. Thanks |
#7
|
|||
|
|||
How to lookup multiple values and summing them up in one cell
Hi,
You may refer to the following http://office.microsoft.com/en-us/ex...260381033.aspx -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Ari" wrote in message ... What was the exact formular you used to figure this out? That is combining sumif with a vlookup formular? Thanks. "Amr Abul Laban" wrote: I'd like to combine a sumif and vlookup function. Basically I want to lookup a "Name" in a table and sum up the corresponding grades (multiple cells) in another table. Can anyone help. Thanks |
#8
|
|||
|
|||
How to lookup multiple values and summing them up in one cell
reply to CLR
thanks for that info. but one condition i will add, what if that cell a1 has 2 or more same. their value should be add up. i hope you get my clarification. thanks in advance. -- xxxJessexxx "CLR" wrote: You can use a regular Vlookup formula, and instead of returning a value, you can return a formula (or actually the result thereof).........the formula can be in the second column of your table and actually only the result of the formula will show there....... A1= a B1= =VLOOKUP(A1,G1:H5,2,FALSE) G1=a, G2=b, G3=c, G4=d, G5=e H1= =SUM(I1:K1), and copy down to H5 Then, B1 will return the sum of I1:K1........ hth Vaya con Dios, Chuck, CABGx3 "Amr Abul Laban" Amr Abul wrote in message ... I'd like to combine a sumif and vlookup function. Basically I want to lookup a "Name" in a table and sum up the corresponding grades (multiple cells) in another table. Can anyone help. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Summing LOOKUP values | mpjohnston | General Discussion | 3 | August 28th, 2004 09:32 PM |
assigning multiple text values a numeric value and summing a range | Biggs | General Discussion | 1 | July 27th, 2004 06:45 PM |
Summing values with multiple criteria | Peter | Worksheet Functions | 1 | July 22nd, 2004 07:02 PM |
Summing values with Multiple criteria | Peter | Worksheet Functions | 1 | July 22nd, 2004 06:39 PM |