[RESOLVED] Subtract from AVERAGE formula

[MartinLiss]

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?

[jdelano]

You could have a hidden column that is a copy of D, say col XX where each row has "=D{row number}" except row 12 just has a 0. Then use that for the calculation.

[MartinLiss]

Thanks.