Get percentage of whole

S

Susan

I feel like such a doofus asking this simple question!

Excel 2003 .xls spreadsheet

I have a large area, encompassing several columns. I'm trying to figure out what percentage each column's total sum is of the whole total sum.

The formula I'm using is

=(SUM($A$3:$E$10000)/(SUM(A3:A10000)))

This evaluates out to 325.5/6.25, and the answer is 52.08, which I assume is correct, but isn't the information I want! If I format it as a percentage, I get 5208%. That is not correct.

Can anyone help me? Thank you very much!
Susan
 
C

Claus Busch

Hi Susan,

Am Fri, 8 Mar 2013 05:32:15 -0800 (PST) schrieb Susan:
=(SUM($A$3:$E$10000)/(SUM(A3:A10000)))

try:
=SUM(A3:A10000)/SUM($A$3:$E$10000)


Regards
Claus Busch
 
S

Susan

Thank you, Claus.



Hi Susan,



Am Fri, 8 Mar 2013 05:32:15 -0800 (PST) schrieb Susan:






try:

=SUM(A3:A10000)/SUM($A$3:$E$10000)





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top