Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summating vlookup or index formulas
in response to this article
http://office.microsoft.com/en-us/ex...0corresponding what is the formula that can summate all the corresponding values next to the name ashish...in other words what formula would be responsible for adding 234 534 adn 834 or any other possible corresponding value that would be next to ashish. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summating vlookup or index formulas
I get nothing clicking on that link. IE opens with an empty window? However,
the name "Ashish" is familiar and I think I know what that link is about. I'll take a guess: =SUMIF(A1:A10,"Ashish",B1:B10) Or, if "Ashish" is in cell D1: =SUMIF(A1:A10,D1,B1:B10) Biff "pkhare3" wrote in message ... in response to this article http://office.microsoft.com/en-us/ex...0corresponding what is the formula that can summate all the corresponding values next to the name ashish...in other words what formula would be responsible for adding 234 534 adn 834 or any other possible corresponding value that would be next to ashish. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summating vlookup or index formulas
the web tutorial that i refer to for my problem is the following by a dude
named ashish: http://office.microsoft.com/en-us/ex...CL100570551033 this link should work "pkhare3" wrote: in response to this article http://office.microsoft.com/en-us/ex...0corresponding what is the formula that can summate all the corresponding values next to the name ashish...in other words what formula would be responsible for adding 234 534 adn 834 or any other possible corresponding value that would be next to ashish. http://office.microsoft.com/en-us/ex...CL100570551033 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summating vlookup or index formulas
Ok, that link is what I thought it was. The formula I suggested will do what
you want. Biff "pkhare3" wrote in message ... the web tutorial that i refer to for my problem is the following by a dude named ashish: http://office.microsoft.com/en-us/ex...CL100570551033 this link should work "pkhare3" wrote: in response to this article http://office.microsoft.com/en-us/ex...0corresponding what is the formula that can summate all the corresponding values next to the name ashish...in other words what formula would be responsible for adding 234 534 adn 834 or any other possible corresponding value that would be next to ashish. http://office.microsoft.com/en-us/ex...CL100570551033 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summating vlookup or index formulas
Fuk yeah, it works nows, tahnks alot, do you work for microsoft?
"T. Valko" wrote: I get nothing clicking on that link. IE opens with an empty window? However, the name "Ashish" is familiar and I think I know what that link is about. I'll take a guess: =SUMIF(A1:A10,"Ashish",B1:B10) Or, if "Ashish" is in cell D1: =SUMIF(A1:A10,D1,B1:B10) Biff "pkhare3" wrote in message ... in response to this article http://office.microsoft.com/en-us/ex...0corresponding what is the formula that can summate all the corresponding values next to the name ashish...in other words what formula would be responsible for adding 234 534 adn 834 or any other possible corresponding value that would be next to ashish. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summating vlookup or index formulas
You're welcome!
do you work for microsoft? No Biff "pkhare3" wrote in message ... Fuk yeah, it works nows, tahnks alot, do you work for microsoft? "T. Valko" wrote: I get nothing clicking on that link. IE opens with an empty window? However, the name "Ashish" is familiar and I think I know what that link is about. I'll take a guess: =SUMIF(A1:A10,"Ashish",B1:B10) Or, if "Ashish" is in cell D1: =SUMIF(A1:A10,D1,B1:B10) Biff "pkhare3" wrote in message ... in response to this article http://office.microsoft.com/en-us/ex...0corresponding what is the formula that can summate all the corresponding values next to the name ashish...in other words what formula would be responsible for adding 234 534 adn 834 or any other possible corresponding value that would be next to ashish. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX? VLOOKUP? | Excel Discussion (Misc queries) | |||
Can you link HLOOKUP AND VLOOKUP formulas and return their interce | Excel Worksheet Functions | |||
Vlookup and Cells with Formulas | Excel Discussion (Misc queries) | |||
Using 8/23/2005 with INDEX, MATCH, VLOOKUP and IF | Excel Worksheet Functions | |||
Which to use - if, vlookup, match, index, offset, vba? | Excel Discussion (Misc queries) |