In my workbook I have a named range called MonthPoints on worksheet 'Rank' which currently refers to all of column D except for the single heading row. That named range is defined as:
=OFFSET(Rank!$D$6,0,0,COUNTA(Rank!$D:$D)-5,1)

In range("N2") on the same worksheet I have this formula:
=AVERAGE(MonthPoints)

The problem I have is that I'd like the average to permanently ignore the value in D12. Can either one of those formulas be modified to do that?