News for hackers. Stuff that matters.

A comment on Ask HN: What can't you do in Excel?. Parent comment

Re:Ask HN: What can't you do in Excel? by CatDancer on Sunday January 11, 2009 @05:25PM (#429727)
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.

[ Parent | on HN ]
Re:Ask HN: What can't you do in Excel? by amobilebiz on Sunday January 11, 2009 @10:43PM (#430050)
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.
[ Parent | on HN ]