A question about microsoft excel?

With Microsoft Excel, you start with the equals sign, not the at symbol:

=SUM(A1:A1000)

The SUM function treats blank cells as 0. FYI, the AVERAGE function treats blank cells as if they didn't

exist.

-----A---

1 - 12

2 - 14

3 - 0

4 - 15

5 - 19

=AVERAGE(A1:A5) returns with 12

-----A---

11 - 12

12 - 14

13 - <blank>

14 - 15

15 - 19

=AVERAGE(A11:A15) returns with 15, not 12

Go to the cell immediately below or beside the column or row you want to add. Then you have two choices you can either manually type the formula to sum in or use the button at the top that looks like a backward capital. Both will sum.

To type it in manually you type @sum(a1:a1000) if you want to add the column a from cell a1 down to a1000 for example. The colen seperates the start cell and the finish cell in the range name.

If you use the auto sum it will name the range immediately above up until it hits a space or across until I hits a space. Empty cells aka spaces stop automated functions but you can manually drag or edit the formulas after or during if you need to.

Try "SUM(A1:A5)" were the a1 and a2 are teh range of cells that you want to add up