+ Reply to Thread
Results 1 to 2 of 2

iferror with array formula

  1. #1
    Forum Contributor
    Join Date
    07-29-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    365
    Posts
    255

    iferror with array formula

    Hi

    how would I combine =iferror( ***insert array formula*** , "")

    where my array formula is

    =MEDIAN(IF($A$2:$A$12=$E2,IF($C$2:$C$12=F$1,$B$2:$B$12)))

    Q
    Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,800

    Re: iferror with array formula

    That would become:

    =IFERROR(MEDIAN(IF($A$2:$A$12=$E2,IF($C$2:$C$12=F$1,$B$2:$B$12))),"")

    or you could write it as this:

    =IFERROR(MEDIAN(IF(($A$2:$A$12=$E2)*($C$2:$C$12=F$1),$B$2:$B$12)),"")

    where the * is equivalent to AND.

    Whichever version you use, you must confirm the formula using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual Enter.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Can't seem to use IFERROR with an array formula I have ccreated
    By forrestgump1980 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-05-2021, 02:26 AM
  2. [SOLVED] IFERROR, INDEX, MAX, MATCH Get latest date with array
    By beau.young92 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 27
    Last Post: 11-28-2019, 07:37 AM
  3. IFERROR, INDEX, MAX, MATCH Get latest date with array
    By beau.young92 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2019, 07:20 PM
  4. [SOLVED] Modify an IFERROR INDEX array function to LINK a cell to ROW reference
    By paulmacro in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-28-2015, 09:43 AM
  5. [SOLVED] Iferror, index, array...
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2014, 07:56 PM
  6. xlfn.IFERROR or IFERROR don't work in Excel 98-2003
    By dj_danu01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 02:53 AM
  7. Using IFERROR and FREQUENCY functions in an array
    By mcmassok in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-30-2013, 08:39 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1