Hi Paul,

My worksheet has blocks of 6 rows for each item I'm reporting on.

I am not sure what you are doing.

Pls. try to enter 6 formulas for a block (even if you do it manually,
without copying) and then copy all 6 formulas and paste them down your
list. The range for the paste operation must be a multiple of 6 (arrgh,
bad english, = 6, 12, 18...60... rows, ok?).

arno