Percent Profit is

=(100 - SUM(Costs involved))/SUM(Costs involved)

HTH,
Bernie
MS Excel MVP


"Sammy" wrote in message
...
The final sum/total must remain the same: $100.00.
Working backwards the % of profit has to change so whatever changes are made
to the subtotals, the final cost remains $100.00.