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.