new to excel
From: Michael (anonymous_at_discussions.microsoft.com)
Date: 03/11/04
- Next message: Jerry W. Lewis: "Re: Random numbers"
- Previous message: Norman Harker: "Re: new to excel"
- In reply to: Mike: "new to excel"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 10 Mar 2004 19:39:41 -0800
Hi Mike.
Try:
=SUM(F4:H4)+(I4*2)+(J4*3)+(K4:M4)
Press F2 & then Ctrl+Shift+Enter. This will solve the
first line equation.
Now Click the little black box in the bottom right of the
cell and drag the formula down as many lines as you like.
Regards
Michael
>-----Original Message-----
>I am new to this program and am trying create a database
>with the following formula:
>=F4+G4+H4+(I4*2)+(J4*3)+K4+L4+M4
>I know there must be some way to extend this formula to
>rows 5 through 277 without having to type the formula
>into all 277 boxes with the different row numbers! I'm
>sure it is probably ridiculously easy to do, but I cannot
>find an answer in references that I am using and I am
>getting frustrated! Can someone help me out with this?
>Thanks
>
>you can e-mail me directly if you like at
>tigersguy@hotmail.com
>.
>
- Next message: Jerry W. Lewis: "Re: Random numbers"
- Previous message: Norman Harker: "Re: new to excel"
- In reply to: Mike: "new to excel"
- Messages sorted by: [ date ] [ thread ]