Re: 2003/2007 Formula issues

Discussion in 'Microsoft Excel Discussion' started by joeu2004, Mar 20, 2012.

  1. joeu2004

    joeu2004 Guest

    "Darren Goddard" <> 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)))
     
    joeu2004, Mar 20, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Richard Wollmarker

    Re: German & English excel formula compatibility issues.

    Richard Wollmarker, Jun 30, 2003, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    1,766
    Richard Wollmarker
    Jun 30, 2003
  2. Jan Karel Pieterse

    Re: German & English excel formula compatibility issues.

    Jan Karel Pieterse, Jul 2, 2003, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    799
    Jan Karel Pieterse
    Jul 2, 2003
  3. news.microsoft.com

    Excel 2003-Sp2 - Resize the formula box in the formula bar

    news.microsoft.com, Apr 26, 2007, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    1,493
    Bob Flanagan
    Apr 26, 2007
  4. Ben C.

    Excel 2003 Array Formula in Excel 2007

    Ben C., Jul 7, 2008, in forum: Microsoft Excel Discussion
    Replies:
    6
    Views:
    1,745
    JustAsking
    Jul 29, 2008
  5. waynen

    Excel 2007 vs 2003 Formula problem

    waynen, Apr 29, 2009, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    2,863
    T. Valko
    Apr 30, 2009
Loading...

Share This Page