Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Formula for a group of rows with same math

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
willshak - 18 Nov 2006 17:01 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.