The IFERROR function can only be used in Excel 2007.

Try this array formula** :

=LOOKUP(1E100,CHOOSE({1,2},0,AVERAGE(IF(MOD(COLUMN (G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC50,G5:HC5)))))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
I am using excell 2007 & this formula works
{=IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC50,G5:HC5))),0)}
When i upload this workbook to a 2003 version this formula does not work I
get
{=_xinfl.IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC50,G5:HC5))),0)}
or somthing close to this
Then in the cell with this formula has a NAME error WHY & HOW could i fix