Writing a formula with several criteria?

[Rodney]

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.

 

[Luke M]

To clarify (your post got distorted).
It looks like row 2 has the number/value of the trip (from 1 to 6)
row 3 has percent completed on that trip?
So, if you do 10% of work on the 2nd trip, it should be 2 * 10% (worth twice
as much as 10% done on 1st trip?)

If the answer is "yes" to all this:
=SUMPRODUCT(B2:G2,B3,G3)

 

[Bernard Liengme]

=SUMPRODUCT( B1:B6, C1:C6)
I have assumed the 'values' to be in B1;B6, the 'percentages' in C1:C6 -
adjust as needed
best wishes

 

[Rodney]

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 reflect 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 2st Trip the total needs to be 24%
3rd Trip the total needs to be 36%
4th Trip the total needs to be 84%
--
Rodney

To clarify (your post got distorted).
It looks like row 2 has the number/value of the trip (from 1 to 6)
row 3 has percent completed on that trip?
So, if you do 10% of work on the 2nd trip, it should be 2 * 10% (worth twice
as much as 10% done on 1st trip?)

If the answer is "yes" to all this:
=SUMPRODUCT(B2:G2,B3,G3)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Value 1 2 3 4
5 TOTAL
The value represents the percentage of a job to build a house, for example