4 ms·
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 :)
by 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 agoYou 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.