Need HELP with Formula

K

k.floyd

I have two spread sheets in one work book. The first sheet is named DRA
SCHEDULE 1-9 and the second is named DRAW SCHEDULE 10-18. On the firs
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 t
d21:u21 in the second sheet. The annswer will appear in y21 on th
second sheet.

Your feedback is most appreciated.

Thanks for you help :
 
A

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
 
J

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
 
Top