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

« Copy Rows based on count of last row of another Column | Copy compare worksheets »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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