Hi!

One way:

Assumptions:

Row 1 is the header row
Values to sum are in row 2 to row 10

=SUM(OFFSET(A1,1,MATCH("column ex",1:1,0)-1,ROWS(A2:A10)))

Biff

"nockam" wrote in
message ...

I have a sheet where i export in data that has to have text to columns
ran on it in order to get it out of a single cell. From there I need to
find the column with the heading "column ex" Then add "column ex" The
problem is "column ex" is not always in the same column, somtimes its
column B, or C, or D all the way up to X. Does anyone have any
suggestions? I have been trying this now for an hour with several
differnet ways but so far i havent had any luck. Thanks Garrett


--
nockam
------------------------------------------------------------------------
nockam's Profile:
http://www.excelforum.com/member.php...o&userid=15744
View this thread: http://www.excelforum.com/showthread...hreadid=500507