Forum Discussion
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...
Okay. Second parameters 4 ignores nothing, if to ignore errors it shall be 6.
- That was for a clean data set,
I used 3 (=AGGREGATE(12,3,E$2:E$87)) for a calculated data set
Thanks Again