2003/2007 Formula issues

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


0
3/20/2012 9:12:20 AM
excel 39879 articles. 2 followers. Follow

1 Replies
1911 Views

Similar Articles

[PageSpeed] 39

"Darren Goddard" <darren.goddard@virginmedia.co.uk> wrote:
> 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))) 

0
joeu20041 (141)
3/20/2012 4:20:42 PM
Reply:

Similar Artilces: