OK.
In cell D2, write =SUM((B2/$B$2)/100). Drag this down to D4, and across
to E4. This will give you the relative percentages of B2.
I've attached the sheet. Based upon the data you gave here.
I hope it helps.
Adam
+-------------------------------------------------------------------+
|Filename: Example of percentages.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4601 |
+-------------------------------------------------------------------+
--
A S-D
------------------------------------------------------------------------
A S-D's Profile:
http://www.excelforum.com/member.php...o&userid=33227
View this thread:
http://www.excelforum.com/showthread...hreadid=530474