Assuming the columns are A B C
in cell C1 enter formula =B1/Total
copy that formula down the column
now if you name the cell that has the total you can then use the word
Total
select the cell that has the total then
open the window beside the = sign by the formula box and type in the
word Total then enter
now any time you write the word Total in a formula in the workbook it
will reffer to that cell range