Hi Jim,

Try the attached.

As you'll see, I've inserted 3 columns with round & offset values that the handicap formula in I1 uses to work out which rows to draw the averages from. You can hide those columns if you don't want to see them.

Do note that, if you change the # of rows before the handicap table starts, the offsets will need to be adjusted accordingly.

Attached Files

IF Example.xls (22.5 KB, 27 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]