One Formula Referenced In Many Cells

[alsaleh]

Hi,
How can I write formula (sum) that can be referenced by many cells in
a sheet. That is, I have many cells under column A to be added to
many cells under B column, the result of each operation will be stored
in cells under Column C.


MTIA

 

[David Biddulph]

If you mean that in C1 you want the formula =A1+B1, and in C2 you want the
formula =A2+B2, and in C3 you want the formula =A3+B3, and so on, there are
many ways of doing it.
1 Select the whole range of cells that you want to use in column C, and
if C1 is the active cell, enter =A1+B1 and this will automatically fill the
relevant formula down the rest of the range.
or 2 Select C1 and enter the formula then click on the bottom right-hand
corner of C1 and you'll get a black square fill handle.
Either
2a Double-click on the fill handle and it will fill down as far as you've
got data in column B
or
2b Drag the fill handle down as far as you want it
or 3 Put the formula in C1 as above, cpy cell C1, then select the rest of
the range you want in column C and paste.
or ...

 

[alsaleh]

David
Thanks for your help.
I did try the above method. However, I was thinking of writing the
formula once in C1 and let it then read all cells in Col A and Col B
without further action. Is it possible by Excel way, like certain
functions?

I know it can be done through VBA by using certain Event like (cell on
leave).

 

[Eduardo]

Hi,
not clear what you want to sum, if you want dif cell from A + different
cells from B you can use for example

=A1+A4+B10+B15

 

[alsaleh]

Ed,
I want to sum cells in Col A + cells in Col B, then store the result
in cells of Col C, respectively.
So, A1+B1=C1
A2+B2=C2
'
'
'
'
'
The way I wish to do it is to store a single formula in any place (May
be in C1) then have it automatically sum any numbers in A2, add it to
B2, store the result in C2.

 

[David Biddulph]

I told you four different ways of doing it. If none of them are good enough
for you, you're on your own.
If you are saying that you want a formula in C1 to write also to C2 and C3
and onwards, then you're out of luck. Formulae don't do that.

 

[Eduardo]

Hi Alsaeh,
in C1 enter

=A1+B1

then copy formulas down

If you want to have a total of column C at the bottom enter

=sum(C1:C1000)

change range to fit your needs