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)

Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

© 2010 Figurate Ltd Suffusion WordPress theme by Sayontan Sinha