PDA

View Full Version : Solved: Percentage Total



spartacus132
08-18-2006, 08:10 AM
Hello Helpers!
If i have a column, say column A, with 100 rows populated with numbers and my 104th row contains the total(sum) of all the numbers in the above 100 rows. is there a way, that i can automatically populate the adjacent column with a percentage value in regards to the total.

Cheers,
Anupam

Bob Phillips
08-18-2006, 08:17 AM
Hello Helpers!
If i have a column, say column A, with 100 rows populated with numbers and my 104th row contains the total(sum) of all the numbers in the above 100 rows. is there a way, that i can automatically populate the adjacent column with a percentage value in regards to the total.

Cheers,
Anupam

=A2/$A$104

and format as a percentage.

spartacus132
08-18-2006, 08:22 AM
:) xld, your suggestion was the quick and dirty method. my example had just 100 rows but there are cases where i have about 4000 rows...and i was wondering if there is a better way than sticking a cell formula in all of those adjacent 4000 rows.

Thanks for the prompt attn. though!

Bob Phillips
08-18-2006, 09:00 AM
:) xld, your suggestion was the quick and dirty method. my example had just 100 rows but there are cases where i have about 4000 rows...and i was wondering if there is a better way than sticking a cell formula in all of those adjacent 4000 rows.

Thanks for the prompt attn. though!

Better in what way? If you want the percentage of every row, there is no other way that I can see.

mdmackillop
08-18-2006, 09:22 AM
Not better, just different
=A1:A4000/A4001 and enter as an array formula.