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? |
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