Finding averages

[wutzke]

I have a range of cells containing operatonal counts

Something similar to
http://spreadsheets.google.com/ccc?key=p5XvDvb4SUVgeQHRycNcWUQ&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

 

[Mike H]

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]

pretty slick
actually I'd like to create a UDF that returned the percentage value
on a new sheet.
and then move down to the next group, do the same until there wasn'y
any groups left on the first sheet.

so cell on a second sheet would contain =FindPert()



Function FindPert()
'Select Next Range from Sheet1
'Find Total Counts excluding header row and column and store in
variable
'Return Rounded Result
End Function


(new google spreadsheet as example)
http://spreadsheets.google.com/ccc?key=p5XvDvb4SUVjzxF_n7_0Wdw