| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sumif based on column A and title of another column
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, sorting columns automatically by clicking column title | Excel Discussion (Misc queries) | |||
| chart label reference based on the column number | Charts and Charting in Excel | |||
| chart label reference based on the column number | Charts and Charting in Excel | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| How do I set up a click "column title" and auto arrange data form. | Excel Discussion (Misc queries) | |||
Threaded Mode
