I would like to divide a column of numbers by the sum. However, when I
copy/paste the formula throughout the worksheet, I receive errors

Divide by the sum of what?

Show us the formula you're getting the errors with.


Gord Dibben MS Excel MVP

On Mon, 20 Aug 2007 16:50:02 -0700, eric wrote:

I would like to divide a column of numbers by the sum. However, when I
copy/paste the formula throughout the worksheet, I receive errors

=A1/SUM(A$1:A$100) or A1/SUM(A:A) ?

If you are getting errors, and you want the help of the group in solving
your problem, then you are more likely to get useful help if you tell the
group what errors you are getting. If you are getting error messages, tell
us what the message is. If you are getting different results what what you
expect, tell us what formula you are using, what values are in the input
cells, what value you were expecting, and what value you got. Otherwise, if
we have to guess the right question, it reduces the chances of us also
guessing the right answer.
--
David Biddulph

"eric" wrote in message
...
I would like to divide a column of numbers by the sum. However, when I
copy/paste the formula throughout the worksheet, I receive errors