Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Not Looping | Excel Discussion (Misc queries) | |||
looping through series | Charts and Charting in Excel | |||
Looping | Excel Discussion (Misc queries) | |||
Looping through textboxes | Excel Discussion (Misc queries) | |||
looping trouble | Excel Discussion (Misc queries) |