Writing a formula with several criteria?

R

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.
 
L

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)
 
B

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
 
R

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


Luke M said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top