Array... Sort of...

[Egon]

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.

 

[Bob Phillips]

Something like

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

--

HTH

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

 

[Alan Beban]

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