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