chas

=SUMIF(E1:E18,"blue sheets",C1:C18)

entered in C20 or E20 or wherever you desire.

Column E contains cells that have the string "blue sheets"

Column C has numerics.


Gord Dibben Excel MVP


On Mon, 21 Nov 2005 17:06:16 -0600, chazmac
wrote:


Hi, I'm wondering if there is a way to lookup every instance of say
"blue sheets" in an excel file, move left 2 columns, pick up the
numerical value that resides in that column for every instance of "blue
sheets" and give a sum total in a cell at the bottom of the sheet? I'm
an excel formula "newbie" so please be kind in any explanation. :-)