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