Thank you soo much! I have been stuck here for an hour trying to figure it
out and nobody is around to help me, thank you thank you thank you!!!!

"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.