Hi,

1. Assuming I summing A1:A25 in B25. You can enter the formula on say B25,
then highlight B25 down to B49 and then drag the fill handle. The formula
will repeat every 25 or so lines and refer to the appropriate range. But
they will be 25 rows apart. If you want them all together, select from row
25 down to the last formula. Press Ctrl+G, Special, Blanks. Press Ctrl+-
(control minus) and shift cells up.

2. You can use a formula approach with INDIRECT.


--
Thanks,
Shane Devenshire


"Erin Dicks" wrote:

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.