Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need HELP with Formula
I have two spread sheets in one work book. The first sheet is named DRAW SCHEDULE 1-9 and the second is named DRAW SCHEDULE 10-18. On the first sheet in Y21 there is this formula that reads like this =sum(d21:u21). I need to know what the formula is to add y21 in the first sheet to d21:u21 in the second sheet. The annswer will appear in y21 on the second sheet. Your feedback is most appreciated. Thanks for you help :) -- k.floyd ------------------------------------------------------------------------ k.floyd's Profile: http://www.excelforum.com/member.php...o&userid=28677 View this thread: http://www.excelforum.com/showthread...hreadid=499844 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need HELP with Formula
K,
Try this: =SUM(D21:U21)+'DRAW SCHEDULE 1-9'!Y21 You should note that you can create these formulas by "pointing" to things on the spreadsheet. It's a little difficult to explain without your seeing it, but try this. On your first sheet, in cell Z21 do this: Type: =sum( Now, click on cell D21 on your second sheet, type a comma, click on cells E21 on your second sheet. Now type ) and then enter. Art "k.floyd" wrote: I have two spread sheets in one work book. The first sheet is named DRAW SCHEDULE 1-9 and the second is named DRAW SCHEDULE 10-18. On the first sheet in Y21 there is this formula that reads like this =sum(d21:u21). I need to know what the formula is to add y21 in the first sheet to d21:u21 in the second sheet. The annswer will appear in y21 on the second sheet. Your feedback is most appreciated. Thanks for you help :) -- k.floyd ------------------------------------------------------------------------ k.floyd's Profile: http://www.excelforum.com/member.php...o&userid=28677 View this thread: http://www.excelforum.com/showthread...hreadid=499844 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need HELP with Formula
In your cell Y21 on your send sheet (...10-18) enter:
='DRAW SCHEDULE 1-9'!Y21+SUM('DRAW SCHEDULE 10-18'!D21:U21) HTH "k.floyd" wrote: I have two spread sheets in one work book. The first sheet is named DRAW SCHEDULE 1-9 and the second is named DRAW SCHEDULE 10-18. On the first sheet in Y21 there is this formula that reads like this =sum(d21:u21). I need to know what the formula is to add y21 in the first sheet to d21:u21 in the second sheet. The annswer will appear in y21 on the second sheet. Your feedback is most appreciated. Thanks for you help :) -- k.floyd ------------------------------------------------------------------------ k.floyd's Profile: http://www.excelforum.com/member.php...o&userid=28677 View this thread: http://www.excelforum.com/showthread...hreadid=499844 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Hide formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |