Formula for a group of rows with same math

[willshak]

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

 

[Bernard Liengme]

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.

 

[Niek Otten]

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"

--
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
| 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
|
| --
| Bill
| in Hamptonburgh, NY
| To email, delete the double zeroes after @

 

[Gord Dibben]

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

 

[willshak]

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

Wow, Three identical correct answers in less than 45 minutes. Thanks
Bernard, Niek and Gord.

 

[Dana DeLouis]

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.