Different Example: Writing a formula with several criteria?
 

I tried to fix my first post so maybe it will make more since. On every trip
I need the total in each row to update. So the total for Site
Preparation after the first trip needs to be 2%, on the secound Trip it needs
to be 100%. Same for the other rows.
Framing 2nd Trip the total needs to be 24%
3rd Trip the total needs to be 36%
4th Trip the total needs to be 84%
Plumbing 3rd Trip the total needs to be 2%
4th Trip the total needs to be 4.8 round to 5%
I know the formula to get the percentage but how do I get it to update after
the next trip?
Jan Feb Mar Apr
Trip Trip Trip Trip
Value 1 2 3 4
TOTAL
Site Prep (10%) 20% 100% ______
Framing (12%) 20% 30% 70% ______
Plumbing (8%) 30% 60% ______


--
Rodney