Simple Formulae

All formulae in Excel begin with an = sign.

Suppose you wish to add the contents of cell A1 and A2 and display the answer in cell A3, put the formua into cell A3:

=A1+A2

To add a column of numbers from A1 down to A10, and put the total in cell B1, you could put
=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10
in cell B1, but a quicker way would be to use the Sum function:

=sum(A1:A10)

Advertisements

Comments are closed.