2003/2007 Formula issues

[Darren Goddard]

Hi,

First time poster here.

I have the following formula in 2007 which works fine. However a number of people here at work still use 2003 so I am experiencing some compatibility issues.

=IFERROR(AVERAGEIF(Data!$AN:$AN,Tables!$H$49:$H$111,Data!$AE:$AE),NA())

I have tried a number of times to replicate it in 2003 but I cant seem to get it to work. If I had hair I would be pulling it out over this one.

Any help would be greatly appreciated

Thanks

Darren

 

[joeu2004]

a number of people here at work still use 2003 so I am
experiencing some compatibility issues.
=IFERROR(AVERAGEIF(Data!$AN:$AN,Tables!$H$49:$H$111,Data!$AE:$AE),NA())

=IF(COUNTIF(Tables!$H$49:$H$111,Data!$AE:$AE)=0, NA(),
SUMIF(Tables!$H$49:$H$111,Data!$AE:$AE)
/ COUNTIF(Tables!$H$49:$H$111,Data!$AE:$AE))

or this array-entered formula (press ctrl+shift+Enter instead of just
Enter):

=IF(COUNTIF(Tables!$H$49:$H$111,Data!$AE:$AE)=0, NA(),
AVERAGE(IF(Tables!$H$49:$H$111=Data!$AE:$AE,Tables!$H$49:$H$111)))