ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   in excel, how do i set up a spread sheet that automatically total. (https://www.excelbanter.com/new-users-excel/4862-excel-how-do-i-set-up-spread-sheet-automatically-total.html)

jgus

in excel, how do i set up a spread sheet that automatically total.
 
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

"jgus" wrote in message
...
i want to set up a spread monthly numbers sheet that automatically totals
how
do i do that?





All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com