Formulas

  • Thread starter Thread starter rlvlach
  • Start date Start date
R

rlvlach

How do I have it so that Excel creates a new column of numbers that are
the sum of individual rows of two or more other columns? Also, how
would i create a colunm of numbers which contains values that are the
sum of the previous cell and some constant, or variable. ((Ex.
A2=4+A1)--I would like this to occur for an entire column up to a
specified row.)
I appreciate any help.
Thanks.
 
Hi

To have Excel add individual cells, whether they are sums or not, just enter
= in the destination cell and then select each cell in turn with + in
between (eg =A6+b6+c6)
To add a number to the cell above (eg cell A2) in cell A3 use =A2+4
Using the little + sign in the bottom right hand corner of the cell, you can
then fill that formula down as many rows as you need.

Andy.
 
Back
Top