If what you want is the total of the cells in Columns A and B

=sum(A1:A100) in one cell would give you the total of the data in A1to A100
and =Sum(B1:B100) for column B

If you want a different set of cells, just change the formula.



"Noodles" wrote:

Paul B said it could be done, but not how to do it.

Need to add figures in column. What I am doing now I'm sure is the hard
way:

A B C D
1
2 15.65 15.65 =Sum C1+A2 =Sum D1+B2
3 15.44 15.44 =Sum C2+A3 =Sum D2+B3


After I get the columns totaled I then delete columns C & D etc because they
are not needed anymore. There as to be an easier way.