I need to calculate a % of what each number is against the total without
doing it manaually.
I need to calculate a % of what each number is against the total without
doing it manaually.
=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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks