# Re: 2003/2007 Formula issues

joeu2004
Guest
Posts: n/a

 20th Mar 2012
"Darren Goddard" <(E-Mail Removed)> 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)))

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Debbi Microsoft Excel Worksheet Functions 2 18th Nov 2009 05:47 AM =?Utf-8?B?Sm9obnNhYnU=?= Windows Vista Installation 7 2nd Mar 2007 06:19 AM =?Utf-8?B?bGVjYWJhbGxlcm8=?= Microsoft Excel Programming 1 2nd Nov 2005 12:46 PM =?Utf-8?B?SmFja2ll?= Windows XP Help 1 28th Apr 2004 09:22 PM Muxer Microsoft Excel Programming 2 24th Jul 2003 01:02 AM

Features