Re: Formula for a group of rows with same math

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

On Sat, 18 Nov 2006 12:01:08 -0500, willshak <willshak@xxxxxxxxxx> wrote:

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

.

Relevant Pages

  • Re: Formula for a group of rows with same math
    ... Left-click on that fill handle and drag down column C as far as you wish. ... but arrays and complex formulae allude me. ... I would have to make 25 separate formulae for each ... Three identical correct answers in less than 45 minutes. ...
    (microsoft.public.excel)
  • Re: Sorting an array by another array
    ... establishing the association between the two arrays. ... If one of the custom fields has no corresponding entry in @user_inputs ... the hash value will be undefined. ... "Reply" at the bottom of the article headers. ...
    (comp.lang.perl.misc)
  • Re: Formula for a group of rows with same math
    ... Click cell C1; look at the bottom right corner. ... This looks like it could be a very simple formula or array function ... I would have to make 25 separate formulae for each ...
    (microsoft.public.excel)
  • Re: How do I assign values to an array?
    ... >The advantage is that MyValue is type Single() as specified by the ... I anticipated the OP's response that your Assign macro was too complicated. ... There *IS* both performance drag and additional storage overhead storing dynamic ... large arrays, in which case the function call and processing overhead would ...
    (microsoft.public.excel.programming)
  • Re: Code quality
    ... Sorry but what do you mean by inclusive and exclusive limits? ... of the region (and similarly that the top and bottom are not). ... arrays in C: the valid indices of an array of length LEN are 0 to LEN-1 ... inclusive system. ...
    (comp.programming)