Forum Discussion

Dirk_1999's avatar
Dirk_1999
Copper Contributor
Jun 05, 2024

MEDIAN column of AVERAGEIFS and #DIV/0!

I'm a little confused on this.  I have an array of data that was generated by conditional "AVERAGEIFS" with locations by row and differing conditions by column. The data is pulled from a different p...
excel
Formulas and Functions
  • Dirk_1999's avatar
    Dirk_1999
    Copper Contributor
    Jun 11, 2024

    Thanks,  SergeiBaklan 

    Aggregate worked

    =AGGREGATE(12,4,D:D)

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 11, 2024

      Dirk_1999 

      Okay. Second parameters 4 ignores nothing, if to ignore errors it shall be 6.

      • Dirk_1999's avatar
        Dirk_1999
        Copper Contributor
        Jun 11, 2024
        That was for a clean data set,
        I used 3 (=AGGREGATE(12,3,E$2:E$87)) for a calculated data set
        Thanks Again

Resources