Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I export excel spread sheet to my Palm T3? | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
How to convert the table in word to excel sheet? | Excel Discussion (Misc queries) |