Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Criteria formula
Still looking for an answer to a problem
ITEM %VALUE TRIP TRIP TOTAL Feb Mar Slab (10%) 40% 100% Framing (20%) 40% Electric (15%) 10% Ok here's my problem, I need to have the Total change on every trip by multipling the %Value column by the percentage completed of that Item on each trip. So for trip in Feb there is only one total which is in the Slab row and it should be 4%. The next trip in Mar the total for each Item should be as follows. Slab 100% Framing 8% Electric 1% On each trip that follows the total needs to update every time I put a new percentage in the Trip column. So is there a way to do it. -- Rodney |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Criteria formula
Hi,
Why are you showing Slab percentages as negative? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Rodney" wrote: Still looking for an answer to a problem ITEM %VALUE TRIP TRIP TOTAL Feb Mar Slab (10%) 40% 100% Framing (20%) 40% Electric (15%) 10% Ok here's my problem, I need to have the Total change on every trip by multipling the %Value column by the percentage completed of that Item on each trip. So for trip in Feb there is only one total which is in the Slab row and it should be 4%. The next trip in Mar the total for each Item should be as follows. Slab 100% Framing 8% Electric 1% On each trip that follows the total needs to update every time I put a new percentage in the Trip column. So is there a way to do it. -- Rodney |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Criteria formula
Hi again,
I'm trying to make sense out of your "results" The total for Feb Slab is 10%*40%=4% but Mar Slab is 10%*100% you get 100% I get 10%? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Rodney" wrote: Still looking for an answer to a problem ITEM %VALUE TRIP TRIP TOTAL Feb Mar Slab (10%) 40% 100% Framing (20%) 40% Electric (15%) 10% Ok here's my problem, I need to have the Total change on every trip by multipling the %Value column by the percentage completed of that Item on each trip. So for trip in Feb there is only one total which is in the Slab row and it should be 4%. The next trip in Mar the total for each Item should be as follows. Slab 100% Framing 8% Electric 1% On each trip that follows the total needs to update every time I put a new percentage in the Trip column. So is there a way to do it. -- Rodney |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Criteria formula
Ok, my bad on that with 1 too many zeros. 100% of the work done will be 10%
on the total. I didn't mean for the ( ) to represent a negative, just that they were different from the other percentages. Sorry about that. I've just had a hard time figureing this out. Thanks -- Rodney "Shane Devenshire" wrote: Hi again, I'm trying to make sense out of your "results" The total for Feb Slab is 10%*40%=4% but Mar Slab is 10%*100% you get 100% I get 10%? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Rodney" wrote: Still looking for an answer to a problem ITEM %VALUE TRIP TRIP TOTAL Feb Mar Slab (10%) 40% 100% Framing (20%) 40% Electric (15%) 10% Ok here's my problem, I need to have the Total change on every trip by multipling the %Value column by the percentage completed of that Item on each trip. So for trip in Feb there is only one total which is in the Slab row and it should be 4%. The next trip in Mar the total for each Item should be as follows. Slab 100% Framing 8% Electric 1% On each trip that follows the total needs to update every time I put a new percentage in the Trip column. So is there a way to do it. -- Rodney |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Criteria formula
Hi,
You will find it best to think the problem through as much as possible before posting it, the main reason is that a lot of us won't spend the time asking for clarifation, we will just ignore the question. I'm a little more vocal than many. Anyway, that said.. Assume that your first row of data is row 3 and the total cell is E3 the formula: =B3*C3+B3*D3 Will work or you can simplify it to =B3*(C3+D3) If you are going to have many months then =B3*SUM(C3:D3) will prove easier to expand. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Rodney" wrote: Ok, my bad on that with 1 too many zeros. 100% of the work done will be 10% on the total. I didn't mean for the ( ) to represent a negative, just that they were different from the other percentages. Sorry about that. I've just had a hard time figureing this out. Thanks -- Rodney "Shane Devenshire" wrote: Hi again, I'm trying to make sense out of your "results" The total for Feb Slab is 10%*40%=4% but Mar Slab is 10%*100% you get 100% I get 10%? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Rodney" wrote: Still looking for an answer to a problem ITEM %VALUE TRIP TRIP TOTAL Feb Mar Slab (10%) 40% 100% Framing (20%) 40% Electric (15%) 10% Ok here's my problem, I need to have the Total change on every trip by multipling the %Value column by the percentage completed of that Item on each trip. So for trip in Feb there is only one total which is in the Slab row and it should be 4%. The next trip in Mar the total for each Item should be as follows. Slab 100% Framing 8% Electric 1% On each trip that follows the total needs to update every time I put a new percentage in the Trip column. So is there a way to do it. -- Rodney |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Criteria formula
Each trip there's a new total percentage completed that needs to be multipled
by the number in the value column. In Feb there was 40% of the slab completed but when I went back in March it was 100% completed. So I can't add the two together then multiple by the 10% value that the slab represents. It has to be .10x.40 then .10x 1.00 the next time but still show up in the total column. -- Rodney "Shane Devenshire" wrote: Hi, You will find it best to think the problem through as much as possible before posting it, the main reason is that a lot of us won't spend the time asking for clarifation, we will just ignore the question. I'm a little more vocal than many. Anyway, that said.. Assume that your first row of data is row 3 and the total cell is E3 the formula: =B3*C3+B3*D3 Will work or you can simplify it to =B3*(C3+D3) If you are going to have many months then =B3*SUM(C3:D3) will prove easier to expand. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Rodney" wrote: Ok, my bad on that with 1 too many zeros. 100% of the work done will be 10% on the total. I didn't mean for the ( ) to represent a negative, just that they were different from the other percentages. Sorry about that. I've just had a hard time figureing this out. Thanks -- Rodney "Shane Devenshire" wrote: Hi again, I'm trying to make sense out of your "results" The total for Feb Slab is 10%*40%=4% but Mar Slab is 10%*100% you get 100% I get 10%? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Rodney" wrote: Still looking for an answer to a problem ITEM %VALUE TRIP TRIP TOTAL Feb Mar Slab (10%) 40% 100% Framing (20%) 40% Electric (15%) 10% Ok here's my problem, I need to have the Total change on every trip by multipling the %Value column by the percentage completed of that Item on each trip. So for trip in Feb there is only one total which is in the Slab row and it should be 4%. The next trip in Mar the total for each Item should be as follows. Slab 100% Framing 8% Electric 1% On each trip that follows the total needs to update every time I put a new percentage in the Trip column. So is there a way to do it. -- Rodney |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with a multiple criteria formula | Excel Worksheet Functions | |||
Sum formula for multiple criteria... help? | Excel Discussion (Misc queries) | |||
Formula to sum multiple columns on multiple criteria | Excel Discussion (Misc queries) | |||
multiple criteria formula | Excel Worksheet Functions | |||
How do I set up a formula with multiple criteria? | Excel Worksheet Functions |