Need HELP with Formula

[k.floyd]

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

[Art]

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
>
>

[Jim May]

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
>
>

[Sandy Mann]

Just add it into the SUM in the second sheet:

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


--
HTH

Sandy
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

"k.floyd" <k.floyd.21flba_1136917200.7778@excelforum-nospam.com> wrote in
message news:k.floyd.21flba_1136917200.7778@excelforum-nospam.com...
>
> 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
>