Let's take it one step at a time.

1. Assuming you're starting on row 2, in G2 enter =d2-e2. Fill down.
2. In F2, enter =g2/d2 or =g2/e2 depending on what your want to calculate
the percentage of. Format as percent. Fill down.
3. At the bottom on columns D, E and G, sum the totals, as in =Sum(d2:d100)
4. The percentage calculation for this total row would stay the same.

Regards,
Fred

"Rob" wrote in message
...
Hello All,

I am looking for some help in putting in an excel calculation. I am trying
to automate the calculations but dont quite understand how to achieve
this.

What I need to be able to do is in enter a figure in row D minus row E
then
= row G. In row F I need the percentage difference. Then I need all the
entries in row D added together to give me a total charge. Row E the same
for
the Pay. And then the total of both in another column to give a total
profit
made. And the percentages all added and then averaged out as a total too.

Sounds complicated I know, but I am sure there is a wiz out there they
probably has already done it, or something similar and can do this easy
peasy.

Any help would be wonderful.

Thanks

Rob


--
Newbie