3 ms·

You can do most of that (pretty simply) in excel. For your data C2:C10 - Do a field: sum(C2:C11) Then when you want to add more data - right-click on the row

You can do most of that (pretty simply) in excel. For your data C2:C10 - Do a field: sum(C2:C11) Then when you want to add more data - right-click on the row (11) and "insert" That will update your sum calculation. Also - you can do named fields - so that if you select the fields C2:C11 - then you can name them as "invoices" (in excel 2003 it's in the top left corner - there's a selection box you can type in. Just select and type a name in there). The lets you do the command sum(invoices) Also - don't forget you can do something like sum(C:C) which will just give you everything in C column..

CatDancer 18y ago
Do a field: sum(C2:C11) I.e. leave a blank row at the bottom of my table, and have the sum include that blank row? I actually know about that trick (thanks :)... what I want is a spreadsheet that does what I want without my tricking it.
- amobilebiz 18y ago
  You don't have to trick it in Excel 2003. If you have 10 rows (i.e. c1 thru c10) and in c11 you have the sum if you right click on row 11 and insert row it will insert a row above 11 and update your formula for you in c11 to include the new row.