Array... Sort of...
 

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.

Array... Sort of...
 

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.

Array... Sort of...
 

Egon wrote:
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.

Perhaps a simple illustration. It's really hard to figure out what you
mean by "sum them all together". Sum *what* all together?

Alan Beban