Need Help

[zvjerka]

Hello people....I need to explain what I'm doing so you can see where is my problem.

In my first column (E) are some numbers in 140 rows and at the end is SUM of all numbers in that column(E140). In the next column is formula like this =E5/E140*100 (so I can get percentage of every number to SUM of all numbers in E column) and in the next row of that column is =E6/E140*100 and so on until =E139/E140*100 where E140 is sum of all numbers in first column.

Usually my charts are around 140 rows so if I have couple more rows I just write couple more formulas or delete couple rows if I have less rows and there is no big problem but now I have chart with 800 rows. I just inserted aprox. 700 rows in my chart and formula in my first 140 rows is ok ( =E5/E840*100 all the way to =E139/840*100) but rest of cells are empty and when I try to replicate formula (with "+" in lower right corner of cell, like I do when I'm doing SUM or subtracktion and everything is ok) formula in next cell is wrong and it says =E140/E841*100 and next field say =E141/E842*100 and because E841, E842 and so on and on are empty everything in that column is wrong and has no value.

what do I need to add to formula or do I need some other formula that second part (E840) of it is constant through out whole column and first part (E5 to E839) will change so I dont need to write or correct whole bloody thing, it will take two days to do it.

Really hope someone understands what is my problem and helps me with it....thanx

[FDibbins]

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread
• Please PM me when complete and this post will be removed which will reset the replies to zero…

[mlcb]

EDIT: sorry, I hadn't seen FDibbins reply

You should use absolute references en E840

In E5 try (note the $)
=E5/$E$840
and copy (drag) down

Take a look at
http://www.cpearson.com/excel/relative.aspx

[zvjerka]

it worked!!!!!!!!!!! Thank you mlcb....thank you

[mlcb]

it worked!!!!!!!!!!! Thank you mlcb....thank you

You are welcome.

Have you understood why it worked?

The use of absolute or relative references is a fundamental issue.

Don't miss the link i have provided above.

[zvjerka]

yes I read the article and now I understand why is first part changing and last remains solid, absolute and relative references. Thanx again mlcb

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

[mlcb]

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

I apologize for my replies.

First, I hadn't seen FDibbins post, but when the OP replied to my first post i felt that i could (should) say thanks for the reply.

Sorry again.

[FDibbins]

mlcb saying thanks is always good - continuing the discussion/after repeated requests to the OP to comply with forum rules, is not