Hi Mick,
I am assuming (bad thing to do) that you have numerous columns and that
  (1) you want to be able to put a single %age to calculate for all columns
(2) you want to be able to change the %age

Let's say the columns are d3 to d22 and e3 to e22.
cell d23=sum(d3:d22) and e23=sum(e3:e22)
cell c24= 0.45
cell d24=d23*$c24 and e24= e23*$c24.

cell c24 can be altered to whatever %age you want and it will work on all
the columns.

Hope that helps...Brendan (fellow Irishman?)




At 08:55 PM 1/22/2003 +0000, you wrote:
>Hello
>
>I use Excel 77
>
>I have a long column of numbers A1 through to A20. At the bottom of each
>column (A21) I have a cell the calculates the total. What I'd like to do is
>have another cell below that (A23) that displays a percentage of the that
>total, most the cases it will be minus 60% ... but I don't know what formula
>to use.
>
>Any assistance will be appreciated
>
>TIA ... Mick
>
>              Do you want to signoff PCSOFT or just change to
>                     Digest mode - visit our web site:
>                    http://freepctech.com/pcsoft.shtml

Brendan Smyth
mailto:[log in to unmask]
New Brunswick
Canada

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                   http://freepctech.com/pcsoft.shtml