in excel, how do i set up a spread sheet that automatically total.

[Guest]

i want to set up a spread monthly numbers sheet that automatically totals how
do i do that?

 

[JulieD]

Hi

well it depends a bit on how your data is arranged, but basically to add up
a column of numbers you use the SUM function
e.g.

=SUM(A1:A31)

where A1 is cell reference of the first number that you want to add and A31
is the cell reference of the last cell you want included in the calculation.
The : basically means add up everything between A1 and A31 inclusive.

Hope this helps
Cheers
JulieD