C
Chas
I have a worksheet that is laid out in two sections
The first is as follows:
A B C D F G H I
1 Task PM EE ME Total Jan Feb Mar
2 Controls 2 5 7 14 5 6 3
3 M&S 3 7 10 20 7 7 6
Total 5 12 17
Note: Total is spread manually over months
The second section is below the first & looks like
F G H I J
6 Labor Jan Feb Mar Total
7 PM 1.76 1.9 1.33 5
8 EE 4.24 4.59 3.17 12
9 ME 6 6.5 4.5 17
The end objective is to summarize the labor by month. So in cell G6 i would
like a way to run the formula (B2/F2)*G2 but i need that formula to run for
every row that has PM hours so i end up with total PM hours for Jan etc for
all labor categories. In the end the totals in the column J of the second
section should equal the total row 5 of the first section.
I've tried a sumproduct with no luck. I'm really good with formulas & i'm
pretty good with macros so any type of solution will work.
Any suggestions at all are greatly appreciated.
The first is as follows:
A B C D F G H I
1 Task PM EE ME Total Jan Feb Mar
2 Controls 2 5 7 14 5 6 3
3 M&S 3 7 10 20 7 7 6
Total 5 12 17
Note: Total is spread manually over months
The second section is below the first & looks like
F G H I J
6 Labor Jan Feb Mar Total
7 PM 1.76 1.9 1.33 5
8 EE 4.24 4.59 3.17 12
9 ME 6 6.5 4.5 17
The end objective is to summarize the labor by month. So in cell G6 i would
like a way to run the formula (B2/F2)*G2 but i need that formula to run for
every row that has PM hours so i end up with total PM hours for Jan etc for
all labor categories. In the end the totals in the column J of the second
section should equal the total row 5 of the first section.
I've tried a sumproduct with no luck. I'm really good with formulas & i'm
pretty good with macros so any type of solution will work.
Any suggestions at all are greatly appreciated.