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

J

jgus

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top