vlookup & summing

  • Thread starter Thread starter hcronrath
  • Start date Start date
H

hcronrath

How can I do a vlookup to a certain field, then sum certain colums from the
table array that match the looked up field?
 
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
 
Not much to go on here. Maybe something like this:
=SUMPRODUCT(--(A19:A27=A19),B19:B27)

Regards,
Ryan---
 
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
 
Back
Top