I'm a 68 year old retiree and a basic user of Excel. I can do various
simple tasks, but arrays and complex formulae allude me. Also I don't
know the various names of functions, so I can't use the Help to look up
what I want. This looks like it could be a very simple formula or array
function if I knew the functions or symbols to use.
This is just for a home budget spreadsheet, so no one's fortunes are in
jeopardy. :-)
Let's say I have a number of rows with a math function of A1 + B1 = C1,
A2 + B2 = C2, etc.
I would have to make a separate 'C' column function for each line, like
=A1+B1
=A2+B2
If I had 25 lines, I would have to make 25 separate formulae for each line.
How can I use one identical line function formula for each line in the C
column?
Such as, =A(code for same line number)+ B(code for same line number),
which should give me the result of the particular line in the C column.
This should allow me to Cut and Paste the same formula in each C column,
as lines are added.
Thanks

Signature
Bill
in Hamptonburgh, NY
To email, delete the double zeroes after @
Bernard Liengme - 18 Nov 2006 17:38 GMT
Hello Bill
In C1 type =A1+B1 and use ENTER to complete the formula (better yet click
the green check mark on the formula bar if using a recent version of Excel)
Click cell C1; look at the bottom right corner. You should see a small solid
square called the fill handle.
Let the mouse pointer hover over the fill handle; when you are over it the
point changes from an 'open' cross to a solid +. Click on the fill handle
and drag it down the column. You can also double click the fill handle if
the adjacent column has entries.
The formula gets copied as =A2+B2 in row 2. etc.
Hope this helps; if not then come again.

Signature
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address
> I'm a 68 year old retiree and a basic user of Excel. I can do various
> simple tasks, but arrays and complex formulae allude me. Also I don't know
[quoted text clipped - 23 lines]
>
> Thanks
Niek Otten - 18 Nov 2006 17:39 GMT
Hi Bill,
Excel was made to do just that.
In C1, enter:
=A1+B1
Now fill down column C as far as there is data in Columns A and B. The easiest way to do that: Double-click in the tiny square in
the right hand bottom corner of C1 (C1 should be selected)
If you want Excel to add formulas to C as you add data to A and B:
Tools>Options>Edit tab, check "Extend data range formats and formulas"

Signature
Kind regards from a retiree,
Niek Otten
Microsoft MVP - Excel
| I'm a 68 year old retiree and a basic user of Excel. I can do various
| simple tasks, but arrays and complex formulae allude me. Also I don't
[quoted text clipped - 22 lines]
|
| Thanks
Gord Dibben - 18 Nov 2006 17:42 GMT
In C1 enter the formula =A1 + B1
Hover the cursor over the small black square at bottom right corner of C1.
Left-click on that fill handle and drag down column C as far as you wish.
The formula will increment to =A2 + B2 etc. as it copies down.
If the data in column B contains no blanks, you could just double-click on B1 to
copy down.
Gord Dibben MS Excel MVP
>I'm a 68 year old retiree and a basic user of Excel. I can do various
>simple tasks, but arrays and complex formulae allude me. Also I don't
[quoted text clipped - 22 lines]
>
>Thanks
willshak - 18 Nov 2006 18:38 GMT
> In C1 enter the formula =A1 + B1
>
[quoted text clipped - 35 lines]
>>
>> Thanks
Wow, Three identical correct answers in less than 45 minutes. Thanks
Bernard, Niek and Gord.

Signature
Bill
in Hamptonburgh, NY
To email, delete the double zeroes after @
Dana DeLouis - 20 Nov 2006 16:48 GMT
>If I had 25 lines..
If you had say 25,000 lines, another option might be the following.
Enter formula in C1.
Select your range via the name box. Enter C1:25 (a smaller area to
experiment).
Your range is selected. Hit Ctrl+D to fill down.
Same as the menu command Edit > Fill > Down.

Signature
Dana DeLouis
Windows XP & Office 2003
>> In C1 enter the formula =A1 + B1
>>
[quoted text clipped - 41 lines]
> Wow, Three identical correct answers in less than 45 minutes. Thanks
> Bernard, Niek and Gord.