Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get percentage of whole
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get percentage of whole
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 -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get percentage of whole
Thank you, Claus.
On Friday, March 8, 2013 9:22:19 AM UTC-5, Claus Busch wrote: 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 -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage | Charts and Charting in Excel | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
percentage | Charts and Charting in Excel | |||
percentage | Excel Discussion (Misc queries) | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel |