Ask HN: What can't you do in Excel?

Re:Ask HN: What can't you do in Excel? by ctkrohn on Sunday January 11, 2009 @04:33PM (#429616)

Excel allows you to do named ranges. Select a range, then type its name in the address box. Then, in another cell, you can type =sum(myrange).

[ Parent | on HN ]

Re:Ask HN: What can't you do in Excel? by CatDancer on Sunday January 11, 2009 @04:38PM (#429631)

Doesn't help. The point is Excel doesn't know what range I want when I extend my table, not whether I can give the range a name or not.

[ Parent | on HN ]

Re:Ask HN: What can't you do in Excel? by ecommercematt on Sunday January 11, 2009 @05:13PM (#429705)

Am I missing something, or wouldn't =sum(C:C) work?

[ Parent | on HN ]

Re:Ask HN: What can't you do in Excel? by CatDancer on Sunday January 11, 2009 @05:17PM (#429712)

Would that sum the entire column in the spreadsheet? But what if I wanted to have a couple tables on a page (which I often do), or my sum below the numbers?

[ Parent | on HN ]

Re:Ask HN: What can't you do in Excel? by whatusername on Sunday January 11, 2009 @05:29PM (#429729)

see my post above.

if you use insert row - then formulas respond and will go from C2:C10 to C2:C11 (tested in excel2003 at least)

[ Parent | on HN ]

Re:Ask HN: What can't you do in Excel? by sctb on Sunday January 11, 2009 @07:45PM (#429906)

This is probably useful in many cases, but one could imagine where the inserted row bisects other ranges in other columns unintentionally.

[ Parent | on HN ]