I have a total in column A, B, and C, What I am looking for is the sum of the
three, and then the % of A, B, and C of the total sum.

"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.