Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate percent of a total within a cell
I have several columns of data created from a pivot table. I want the percent
of total for each row, and have been inserting a column next to each number to perform my calculation, and it seems like there should be an easier way. Is it possble to have excel do the calculation within the cell and display the percentage. Example: A B C Virus Cultures Positive Percent of All Cultures 1 Flu A 10 =B1/$B$5 2 Flu B 15 =B2/$B$5 3 RSV 20 =B3/$B$5 4 Adeno 2 =B4/$B$5 5 Total Cultures 500 For formating and ease of presentation I would love to have two columns that look like this: Virus Cultures Positive (percent) Flu A 10 (2%) Flu B 15 (3%) RSV 20 (4%) Adeno 2 (0.4%) As it is my worksheet has grown into a 48 column beast that is a little unwieldy. Thanks for any help or tricks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate percent of a total within a cell
I had a feeling that this wasn't possible. So I started playing with the
Pivot Table and using the calculated fields there, I can get the numbers I want, but it won't show the original count and the calculated percentage, the information is obviously there, I just can't get it to display in the way I want. Any thoughts???? "Sandy Mann" wrote: Assuming that you are entering the Cultures Positive's manually, then no, you cannot have manually entered data and a formula in the same cell. Manually entering data overwrites the formula. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Lost in Microbiology" wrote in message ... I have several columns of data created from a pivot table. I want the percent of total for each row, and have been inserting a column next to each number to perform my calculation, and it seems like there should be an easier way. Is it possble to have excel do the calculation within the cell and display the percentage. Example: A B C Virus Cultures Positive Percent of All Cultures 1 Flu A 10 =B1/$B$5 2 Flu B 15 =B2/$B$5 3 RSV 20 =B3/$B$5 4 Adeno 2 =B4/$B$5 5 Total Cultures 500 For formating and ease of presentation I would love to have two columns that look like this: Virus Cultures Positive (percent) Flu A 10 (2%) Flu B 15 (3%) RSV 20 (4%) Adeno 2 (0.4%) As it is my worksheet has grown into a 48 column beast that is a little unwieldy. Thanks for any help or tricks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate percent of a total within a cell
On Nov 21, 1:08 pm, Lost in Microbiology
wrote: I had a feeling that this wasn't possible. So I started playing with the Pivot Table and using the calculated fields there, I can get the numbers I want, but it won't show the original count and the calculated percentage, the information is obviously there, I just can't get it to display in the way I want. Any thoughts???? "Sandy Mann" wrote: Assuming that you are entering the Cultures Positive's manually, then no, you cannot have manually entered data and a formula in the same cell. Manually entering data overwrites the formula. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Lost in Microbiology" wrote in ... I have several columns of data created from a pivot table. I want the percent of total for each row, and have been inserting a column next to each number to perform my calculation, and it seems like there should be an easier way. Is it possble to have excel do the calculation within the cell and display the percentage. Example: A B C Virus Cultures Positive Percent of All Cultures 1 Flu A 10 =B1/$B$5 2 Flu B 15 =B2/$B$5 3 RSV 20 =B3/$B$5 4 Adeno 2 =B4/$B$5 5 Total Cultures 500 For formating and ease of presentation I would love to have two columns that look like this: Virus Cultures Positive (percent) Flu A 10 (2%) Flu B 15 (3%) RSV 20 (4%) Adeno 2 (0.4%) As it is my worksheet has grown into a 48 column beast that is a little unwieldy. Thanks for any help or tricks!- Hide quoted text - - Show quoted text - Drop cultures positive into the data field a second time. Double click this second drop in field and then click options. Select % of column. This should give you what you need |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate percent of a total within a cell
Mike,
That did the trick, very wonderful! You just saved me hours of banging my head on the wall! Have a great day. Bob " wrote: On Nov 21, 1:08 pm, Lost in Microbiology wrote: I had a feeling that this wasn't possible. So I started playing with the Pivot Table and using the calculated fields there, I can get the numbers I want, but it won't show the original count and the calculated percentage, the information is obviously there, I just can't get it to display in the way I want. Any thoughts???? "Sandy Mann" wrote: Assuming that you are entering the Cultures Positive's manually, then no, you cannot have manually entered data and a formula in the same cell. Manually entering data overwrites the formula. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Lost in Microbiology" wrote in ... I have several columns of data created from a pivot table. I want the percent of total for each row, and have been inserting a column next to each number to perform my calculation, and it seems like there should be an easier way. Is it possble to have excel do the calculation within the cell and display the percentage. Example: A B C Virus Cultures Positive Percent of All Cultures 1 Flu A 10 =B1/$B$5 2 Flu B 15 =B2/$B$5 3 RSV 20 =B3/$B$5 4 Adeno 2 =B4/$B$5 5 Total Cultures 500 For formating and ease of presentation I would love to have two columns that look like this: Virus Cultures Positive (percent) Flu A 10 (2%) Flu B 15 (3%) RSV 20 (4%) Adeno 2 (0.4%) As it is my worksheet has grown into a 48 column beast that is a little unwieldy. Thanks for any help or tricks!- Hide quoted text - - Show quoted text - Drop cultures positive into the data field a second time. Double click this second drop in field and then click options. Select % of column. This should give you what you need |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable - Percent of Current Total | Excel Discussion (Misc queries) | |||
How do I calculate "cummulative percent of total" in a pivot table | Excel Discussion (Misc queries) | |||
Non Adjacent percent average total | Excel Discussion (Misc queries) | |||
HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER? | Excel Worksheet Functions | |||
Percent of total in Pivot tables | Excel Worksheet Functions |