Updating Formulas to use Column Names

[bdav1216]

Formula 1:

=IF(COUNTIFS($B$2:$B2,$B2,$T$2:$T2,$T2)>1,0,1)

Column B Column Name: Order Number
Column T Column Name: Job Number

Formula 2:

=SUMIF($B$2:$B$3829,$B3819,$BW$2:BW$3829)

Column B Column Name: Order Number
Column BW Column Name: Job Count

The above formula is working as expected in the above formulas, but how would I go about updating the formula to use the actual column names (I.E Order Number), not the actual column letter (I.E. B).

Please note that my workbook is re-freshable, meaning that, in the above example, the formula '2' is dynamic....the column 3829 will change to other values (i.e. 3829 or 3831 or 2999, etc.) depending on the number of rows.

[daffodil11]

To do so you'll need to convert your data to a table by selecting all data and using Insert->Table.

=SUMIF(Table1[OrderNumber],"batman",Table1[JobNumber])

The header fields will name themselves when you select the data for the formula, and will autoadjust their range as data is added or removed.

[TMS]

You could define some Dynamic Named Ranges, or convert your data to a Structured Table.