Thread: recursive sums
View Single Post
  #6   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

JMB wrote:
Won't that throw an error if the first row or column is deleted (assuming the
table does not start in cell A1)?


"Bob Phillips" wrote:


=FACT(ROW(A1))


ROW(A1) is not an idiom one would choose if one is concerned with
robustness.

=FACT(ROWS($1:1))

entered in A1, would be robust against inserting rows/columns before the
formula cell and against deleting the first formula row.