Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help in writing a formula | Excel Worksheet Functions | |||
Need help with writing formula please... | Excel Worksheet Functions | |||
Need help writing formula plz.. | Excel Discussion (Misc queries) | |||
Help writing a formula | Excel Worksheet Functions | |||
I need help writing a formula. | Excel Worksheet Functions |