Array... Sort of...

E

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.
 
B

Bob Phillips

Something like

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

--

HTH

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

Alan Beban

Egon said:
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.
Click to expand...
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
 
Top