Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I set up a total amount automatically in excel
Hi I have a spreadsheet for my small business and would find it very
helpfully when I put eg:sold post amount then I would like total on the next column to add these to up automatically I know its properly basic but I am not a computer wiz thanks for your help in advance |
#2
|
|||
|
|||
Select the numbers which you want to total.
From the Standard toolbar, click the AutoSum icon. It's icon is the Greek letter Sigma ? -- Rob van Gelder - http://www.vangelder.co.nz/excel "sue" wrote in message ... Hi I have a spreadsheet for my small business and would find it very helpfully when I put eg:sold post amount then I would like total on the next column to add these to up automatically I know its properly basic but I am not a computer wiz thanks for your help in advance |
#3
|
|||
|
|||
With your data Starting in C2
In D2 enter: =IF(C2<"",SUM($C$2:C2),"") fill down as far as needed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
in excel, how do i set up a spread sheet that automatically total. | New Users to Excel | |||
Enter Data Into Another Excel File Automatically | Excel Worksheet Functions | |||
In Excel, how do you get it to not automatically round my dollars. | Excel Worksheet Functions | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |