I have a row that I want a total in useing the following lay out.
Trip Trip Trip Trip Trip
Trip
Value 1 2 3 4 5
6 TOTAL
Site Prep (10%) 20% 50% 70% 85% 95% 100%
_______

The value represents the percentage of a job to build a house, for example
Site Preparation. Each time I go out to for a inspection I put a percentage
of that line item that is complete.

I need to multipling the percentage of work completed for each trip by the
value, and have it change the total. I just can't seem to think of how to do
it.
--
Rodney