Something like

=SUMIF(A:A,some_value,B:B)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Egon" wrote in message
oups.com...
Ok, I need to look through ONE column for a certain string of data and
if it exists I need to pull the value of the column to the right on the
same row and sum them all together for a particular string.

Is there an elegant way to do this?

Thanks.

J.