Enter this in A2
=A1/SUM($A$1:$C$1)

enter this in B2
=B1/SUM($A$1:$C$1)

enter this in C2
=C1/SUM($A$1:$C$1)

You can format the three cells to read as percentages
Highlite the cells(A2:C2), right click on the mouse and select format
cells=number=percentage, select the decimal you want, and enter

in cell A3 enter a formula such as
=A2*whatever


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=523971