software

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: www.excelforum.com/member.php...oamp;userid=28677
View this thread: www.excelforum.com/showthread...hreadid=499844K,

Try this: =SUM(D21:U21) 'DRAW SCHEDULE 1-9'!Y21

You should note that you can create these formulas by quot;pointingquot; 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

quot;k.floydquot; wrote:

gt;
gt; I have two spread sheets in one work book. The first sheet is named DRAW
gt; SCHEDULE 1-9 and the second is named DRAW SCHEDULE 10-18. On the first
gt; sheet in Y21 there is this formula that reads like this =sum(d21:u21).
gt; I need to know what the formula is to add y21 in the first sheet to
gt; d21:u21 in the second sheet. The annswer will appear in y21 on the
gt; second sheet.
gt;
gt; Your feedback is most appreciated.
gt;
gt; Thanks for you help
gt;
gt;
gt; --
gt; k.floyd
gt; ------------------------------------------------------------------------
gt; k.floyd's Profile: www.excelforum.com/member.php...oamp;userid=28677
gt; View this thread: www.excelforum.com/showthread...hreadid=499844
gt;
gt;

In your cell Y21 on your send sheet (...10-18) enter:

='DRAW SCHEDULE 1-9'!Y21 SUM('DRAW SCHEDULE 10-18'!D21:U21)

HTHquot;k.floydquot; wrote:

gt;
gt; I have two spread sheets in one work book. The first sheet is named DRAW
gt; SCHEDULE 1-9 and the second is named DRAW SCHEDULE 10-18. On the first
gt; sheet in Y21 there is this formula that reads like this =sum(d21:u21).
gt; I need to know what the formula is to add y21 in the first sheet to
gt; d21:u21 in the second sheet. The annswer will appear in y21 on the
gt; second sheet.
gt;
gt; Your feedback is most appreciated.
gt;
gt; Thanks for you help
gt;
gt;
gt; --
gt; k.floyd
gt; ------------------------------------------------------------------------
gt; k.floyd's Profile: www.excelforum.com/member.php...oamp;userid=28677
gt; View this thread: www.excelforum.com/showthread...hreadid=499844
gt;
gt;

Just add it into the SUM in the second sheet:

=SUM(D21:U21,'DRAW SCHEDULE 1-9'!Y21)--
HTH

Sandy
with @tiscali.co.uk

quot;k.floydquot; gt; wrote in
message ...
gt;
gt; I have two spread sheets in one work book. The first sheet is named DRAW
gt; SCHEDULE 1-9 and the second is named DRAW SCHEDULE 10-18. On the first
gt; sheet in Y21 there is this formula that reads like this =sum(d21:u21).
gt; I need to know what the formula is to add y21 in the first sheet to
gt; d21:u21 in the second sheet. The annswer will appear in y21 on the
gt; second sheet.
gt;
gt; Your feedback is most appreciated.
gt;
gt; Thanks for you help
gt;
gt;
gt; --
gt; k.floyd
gt; ------------------------------------------------------------------------
gt; k.floyd's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28677
gt; View this thread: www.excelforum.com/showthread...hreadid=499844
gt;