Writing a formula with several criteria?
 

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

Writing a formula with several criteria?
 

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!*


"Rodney" wrote:

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

Writing a formula with several criteria?
 

=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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rodney" wrote in message
...
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

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 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" wrote:

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!*


"Rodney" wrote:

I have a row that I want a total in useing the following lay out.
Jan Feb Mar Apr May
Trip Trip Trip Trip Trip
Value 1 2 3 4
5 TOTAL
Site Prep (10%) 20% 100% ______
Framing (12%) 20% 30% 70% 100% ______
Plumbing (8%) 30% 60% 80% ______


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