I need to calculate a % of what each number is against the total without doing it manaually.
S Stuart Millner May 3, 2006 #1 I need to calculate a % of what each number is against the total without doing it manaually.
V Vito May 3, 2006 #2 =A1/$A$100 formatted as percent and copied down, where A100 contains the total and A1 to A.... contain the numbers to divide by the total. The $'s "freeze" the cell so that the other cells are always compared with that one cell reference. Adjust cell references to suit your locations.
=A1/$A$100 formatted as percent and copied down, where A100 contains the total and A1 to A.... contain the numbers to divide by the total. The $'s "freeze" the cell so that the other cells are always compared with that one cell reference. Adjust cell references to suit your locations.
