Hi,

Copy your table then in another location
Edit|Paste Special values
Copy the sum (52). Select all the cells in the table then
Edit|Paste special
Select divide and click OK
While the cells are still selected format as a percentage.

I don't get the same answers as you, my table ends up looking like this
0 1 3 5 7 9
A 0.00% 1.92% 1.92% 3.85% 5.77% 1.92%
T 0.00% 0.00% 3.85% 3.85% 1.92% 0.00%
E 3.85% 3.85% 3.85% 5.77% 5.77% 7.69%

I only pasted half the table to prevent linewrap.

Mike

"wutzke" wrote:

I have a range of cells containing operatonal counts

Something similar to
http://spreadsheets.google.com/ccc?k...RycNcWUQ&hl=en

I would like to find the percentage of each count based on the sum of
the entire range.

And then copy the range to another sheet with the percentages showing