Hi there,
I am experiencing some difficulties with a simple median if function in Excel. I have attached the worksheet.
In "mediansnapsholos report matrix" worksheet, you see a table with few numbers. B3 is where the formula begins.
=IFERROR(MEDIAN(IF((YTDraw!$C$2:$C$995='MedianSnapshotLOS Report Matrix'!$A3)*(YTDraw!$A$2:$A$995='MedianSnapshotLOS Report Matrix'!B$2), YTDraw!E$2:E$995)),0)
I have also used control_shift_enter, but I still get 0s. I have done this before, but seem to be stuck at this one.
Is anyone able to assist?
Thanks
Bookmarks