Copying non-contiguous formulas
Hi
Try
=SUM(INDIRECT("A"&INT((ROW()-1)*25)+1&":A"&INT(ROW()*25)))
Note: must start in row 1 as is.
HTH. Best wishes Harald
"Erin Dicks" wrote in message
...
I want to copy down formulas refering to ranges of 25 rows (e.g. sum rows
1-25, sum rows 26-50 etc.) but when I copy the formula down, it only adds
one
to each reference, not 25 (even when I've supplied several correct
formulas).
Are there any tricks for getting around this? I have to copy the formula
down
100 times and don't really want to type each one.
|