Hello all. I am using an array formula to calculate a median. This works except that bizarrely it counts blanks as values and when charted displays them as zero.
So I am trying to add another criteria to the formula. I've tried a few variations, including the one below, but all return a #VALUE error.
When I stepped through the formula evaluation it seemed to evaluate all the blanks as zero. So the problem may be with the data but I can't think what.
Does anyone have any suggestions and/or workarounds?