One Formula Referenced In Many Cells
 

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

One Formula Referenced In Many Cells
 

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 ...
--
David Biddulph


"alsaleh" wrote in message
...
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

One Formula Referenced In Many Cells
 

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).

One Formula Referenced In Many Cells
 

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" wrote:

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


.

One Formula Referenced In Many Cells
 

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.

One Formula Referenced In Many Cells
 

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.
--
David Biddulph

"alsaleh" wrote in message
...
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.

One Formula Referenced In Many Cells
 

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

"alsaleh" wrote:

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.
.