vlookup & summing
 

How can I do a vlookup to a certain field, then sum certain colums from the
table array that match the looked up field?

vlookup & summing
 

there a couple fo ways to do this, pls provide your sample data and the
result you want.

--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis









"hcronrath" wrote:

How can I do a vlookup to a certain field, then sum certain colums from the
table array that match the looked up field?

vlookup & summing
 

Not much to go on here. Maybe something like this:
=SUMPRODUCT(--(A19:A27=A19),B19:B27)

Regards,
Ryan---

--
RyGuy


"xlmate" wrote:

there a couple fo ways to do this, pls provide your sample data and the
result you want.

--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis









"hcronrath" wrote:

How can I do a vlookup to a certain field, then sum certain colums from the
table array that match the looked up field?

vlookup & summing
 

I think the OP means that there is a single match, but having found
the match he then wants to add some columns together from the
corresponding row. Like you, I'm waiting for further details.

Pete

On Feb 11, 8:05*pm, ryguy7272
wrote:
Not much to go on here. *Maybe something like this:
=SUMPRODUCT(--(A19:A27=A19),B19:B27)

Regards,
Ryan---

--
RyGuy



"xlmate" wrote:
there a couple fo ways to do this, pls provide your sample data and the
result you want.

--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.