HELP! How to copy formula in a smart way

[forumboy]

Hi all,

I got a problem here. Say below is my data

A B C
Item Quantity %
1 a1 23
2 b1 15
3 c1 10
4 d1 29
5 e1 17
6 Total 94

To get the percentage, instead of enter =B1/B6 on row 1, =B2/B6 in row, etc Is there a better way that i can copy and paste or a macro that can simplified this issue. Imange if i have 1000 rows, very time consuming even copy and paste.

Thank you.

[8daysaweek.co.uk]

Hi forumboy,

I don't really understand your example data, which numbers are you dividing to get your %?

Assuming you want the percentage of value 23 (Cell C2) out of the total 94 (Cell C7) then =sum(c2/c7) would be a way of doing this.

If you want to copy the formula down, simply use an absolute reference so that the formula becomes: =sum(c2/c$7). Copy this down to the next row and the formula will be: =sum(c3/c$7) (C$7 hasn't changed).

http://www.8daysaweek.co.uk/forums/viewtopic.php?p=233#233

HTH ,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site

[forumboy]

Dear 8daysaweek

Thanks for the info. Thats actually what i want to know. How to use absolute reference in formula.

Thanks a lot.