Excel % Formula Equation Help Please

Gregg777 · #1 02-03-2007, 02:48 PM

Don't know where else to post this...

I am trying to total a column of percentages.

I know how to total a column by highlighting it, then clicking the "Sum" button.

But that doesn't work for percentages.

For example, if I have two fields of 50% and 70%, it is totaling it as 1.2, when it should be totaled as 60% for the average.

Can anyone give me the correct field formula to cut and paste into the formula bar?

Thanks

ncboiler · #2 02-03-2007, 02:54 PM

Click on the cell that you want the formula located. Click the "=" above the sheet. Click the pulldown menu and select "ave". Then follow the instructions. I'm not sure what you are doing but do you really want to average percentages? That's typically not a good idea.

Gregg777 · #3 02-03-2007, 03:36 PM

[ QUOTE ]
I'm not sure what you are doing but do you really want to average percentages?

[/ QUOTE ]

I do, but the way you asked made me realize a better way to do it.

Just sum the totals and then average.

Doh!

Thanks [img]/images/graemlins/grin.gif[/img]

SamIAm · #4 02-03-2007, 04:22 PM

[ QUOTE ]
Don't know where else to post this...

[/ QUOTE ]
CTH.
-Sam

Beavis68 · #5 02-03-2007, 05:52 PM

[ QUOTE ]
[ QUOTE ]
I'm not sure what you are doing but do you really want to average percentages?

[/ QUOTE ]

I do, but the way you asked made me realize a better way to do it.

Just sum the totals and then average.

Doh!

Thanks [img]/images/graemlins/grin.gif[/img]

[/ QUOTE ]

an even better way is to use the average function

=average(cells)