Solved: Percentage of total in excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

anonymos105

Thread Starter
Joined
May 6, 2005
Messages
30
This is a simple one I think just not sure the way to approach it

I have a list of numbers in column "b" with the total at the bottom (ex numbers are cells b1-b4 and the total is in b5) in column "c" I would like the percent of the total ( for ex if b1= $50, b2=$25, b3=$75, b4=$50 and b5 would therefore = $200 as the total c1 should = 25%, c2=13%, c3=38% and c4=25% for a total of 100%)

Ok so my problem is how do I propogate the formula through all of column c. IE I know the formula would be c1 =b1/b5, c2 =b2/b5, c3 =b3/b5 etc... if I try to do the drag box or paste special it keeps adjusting the second value as well ex... c1=b1/b5, c2=b2/b6, c3= b3/b7 etc...

How can I do a large group of cells without manually entering the formulas or having to go through each one and correct the formula manually. The number of cells I am using makes this prohibitive
 

cwwozniak

Chuck
Trusted Advisor
Spam Fighter
Joined
Nov 28, 2005
Messages
66,522
Make the formula for C1 to be C1=B1/$B$5 and then drag-copy it through C2 to C4.

The dollar signs lock the row and column cell references.

EDIT: If you are entering cell references in the formula by clicking in the cells, pressing the F4 key toggles through all of the lock settings (column & row, column only, row only, or none) for the cell.
 

anonymos105

Thread Starter
Joined
May 6, 2005
Messages
30
It's funny i've looked at formulas before and have seen the dollar sign and never quite put two and two together. Anyway that did it and thanks for the help cwwozniak.
 

cwwozniak

Chuck
Trusted Advisor
Spam Fighter
Joined
Nov 28, 2005
Messages
66,522
Glad to have helped out. (y)

As the originator of the thread, you can keep our moderators happy by marking it Solved in the drop down Thread Tools menu above the first post on each page. :)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top