Hi,

Try using this formula

=SUM(OFFSET(A1,1,MATCH("column ex",$A$1:$H$1)-1,1000))

where A1:H1 is where you have the column headers and 1000 at the end of
the formula represents number of rows you have to sum. If you have more
than 1000 rows to sum, you can change it to the actual number of rows.

Regards

Govind.

nockam wrote:
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