summating vlookup or index formulas

[pkhare3]

in response to this article
http://office.microsoft.com/en-us/e...=CL100570551033#Return multiple corresponding

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.

 

[T. Valko]

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]

the web tutorial that i refer to for my problem is the following by a dude
named ashish:

http://office.microsoft.com/en-us/excel/HA012260381033.aspx?pid=CL100570551033

this link should work

 

[T. Valko]

Ok, that link is what I thought it was. The formula I suggested will do what
you want.

Biff

 

[pkhare3]

Fuk yeah, it works nows, tahnks alot, do you work for microsoft?

 

[T. Valko]

You're welcome!

do you work for microsoft?

No

Biff