![]() |
#1
|
|||
|
|||
![]()
I am trying to shorten a formula that runs across two other sheets.
The sheets track hours worked by pay period, two pay periods per sheet. I have a subtotal line that shows the total hours for that pay period, but some payperiods contain hours from two different months. On a summary sheet, I want to show how many hours were worked in any given month, rather than by pay periods. Each Pay Period sheet has two cells from each row I need to put in the formula, regular hours and overtime hours for each day of the month..(cells D & E) The only way I can get the formula to work is to select cells D & E, then the plus sign, then the next row, cells D & E. I have to repeat this 30 times. I cannot get it to work using a colon or comma to shorten the formula. The formula ends up looking like this: (sheet tabs are named one, two three & summary, that's where the formula goes) =SUM(one!D32:E32+two!D17:E17+two!D18:E18+two!D19:E 19+two!D20:E20) Shouldn't I be able to have D17 to E20 all in one bunch? Or at least D17:20 and E17:E20. I get a #value! error. File is attached Last edited by Phylis Sophical; 07-28-2010 at 09:42 AM. Reason: delete smiley |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
nolesca | Excel | 4 | 06-07-2010 08:13 AM |
Print Multiple Sheets Double-Sided | flambe99 | Excel | 1 | 03-12-2010 01:15 PM |
Changing mulitple images sizes with a macro or other | FraserKitchell | Drawing and Graphics | 1 | 01-05-2010 11:53 PM |
unwanted sheets on opening excel | msofficeman | Excel | 3 | 02-24-2009 03:13 PM |
![]() |
majed | PowerPoint | 4 | 01-17-2009 04:24 PM |