Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-28-2010, 09:38 AM
Phylis Sophical Phylis Sophical is offline Forumla between mulitple sheets Windows XP Forumla between mulitple sheets Office 2000
Novice
Forumla between mulitple sheets
 
Join Date: Jul 2010
Location: Canada
Posts: 3
Phylis Sophical is on a distinguished road
Default Forumla between mulitple sheets

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
Attached Files
File Type: xls formula test.xls (41.5 KB, 24 views)

Last edited by Phylis Sophical; 07-28-2010 at 09:42 AM. Reason: delete smiley
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Forumla between mulitple sheets How do I merge data from one sheet in a workbook out into multiple sheets 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
Forumla between mulitple sheets Movement slide with excel sheets majed PowerPoint 4 01-17-2009 04:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft