PC Review


Reply
Thread Tools Rate Thread

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)))

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED Debbi Microsoft Excel Worksheet Functions 2 18th Nov 2009 05:47 AM
ISSUES ISSUES ISSUES! =?Utf-8?B?Sm9obnNhYnU=?= Windows Vista Installation 7 2nd Mar 2007 06:19 AM
Replace formula with IF(error(formula;"";formula) =?Utf-8?B?bGVjYWJhbGxlcm8=?= Microsoft Excel Programming 1 2nd Nov 2005 12:46 PM
Task Manager issues and Virtual Memory issues among other problems =?Utf-8?B?SmFja2ll?= Windows XP Help 1 28th Apr 2004 09:22 PM
Commenting custom formula fields/formula on formula editor Muxer Microsoft Excel Programming 2 24th Jul 2003 01:02 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:11 AM.