Currently I have a speadsheet (30 columns by 400 rows) that was filled
manually with various (sum, min, max, stdev) INDIRECT formulas. Each row on
my summary sheet computes data from each 20 rows of my raw data. EXAMPLE-
Row 1 ... =sum(INDIRECT("d1:d20")), Row 2 ... =sum(INDIRECT("d21:d40")), Row
3 ... sum(INDIRECT(d41:d60")), etc. Is it possible to "FILL" the cells when
I add rows to the summary sheet? I am now manually typing 28 new formulas
for each new added row. Thanks.