Dave O, is there a formula to do the entire column at one time? or do i have
to do each cell one by one every time?

"Dave O" wrote:

If your 20 numbers occupy cells A1:A20 and your sum is in A21, the
formula in cell B1 is =A1/$A$21
Copy this formula for the remaining cells.