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.