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?