LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default looping formulas

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not Looping Roger Excel Discussion (Misc queries) 0 February 26th 08 05:18 PM
looping through series raymondvillain Charts and Charting in Excel 6 July 16th 07 04:33 AM
Looping David T Excel Discussion (Misc queries) 2 August 30th 06 10:51 PM
Looping through textboxes CLamar Excel Discussion (Misc queries) 1 July 12th 06 04:33 PM
looping trouble Hru48 Excel Discussion (Misc queries) 5 May 12th 06 08:35 PM


All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"