Hi!

Try this:

=SUMIF('Test cases'!A2:A300,"=<2K3 TermServ*",OFFSET('Test
cases'!A1,1,MATCH("total",'Test cases'!A1:IV1,0)-1,ROWS('Test
cases'!A2:A300)))

Biff

"Rusty" wrote in message
...
I am trying to create a formula to calculate the total amount of tests
cases.
The formula I have created so far is this
=SUMIF('Test Cases'!A2:C300,"=<2K3 TermServ*",'Test Cases'!C2:C300)
This works if the column I am referencing my data from is Column C
(Sum_Range). Unfortunately this data will not always remain in column C so
I
want to add a criteria that says the Sum_Range will be the column where
the
word <total is in the top row (Row 1)
Note: This autosum is completed on a seperate tab, hence the 'Test Cases'
in the SUMIF statement.
Excel 2003 SP2