Let me try that again. In column A I have a list of 1's giving me a total,
column b I have a list of ones, and C, to = a grand total. Out of the grand
total I need the % of column A, B, and C.

"Gord Dibben" wrote:

=449/578 returns 86% using basic arithmetic.

Your second request is a little vague.

You want a total of column A and total of column B and need a percentage?

=SUM(A1:A10)/SUM(B1:B10) entered in C1

Or maybe =A1/B1 in C1 and copied down to C10

Format all formula cells to percentage.


Gord Dibben MS Excel MVP

On Fri, 27 Jun 2008 21:10:00 -0700, Ball4v
wrote:

I am trying to remember how to manually figure the percentage of the following:

I have a total of 578 out of that 449 is what percent? Then I need to know
how to calculate it in an excel spread sheet for each column.