Hey guys, new here. Visited a lot, but just joined and this is my first post.
I'm using this formula in several columns of a cross-tab, and it seems to be working in most, but not a couple.
So this works: {=MEDIAN(IF(working!O:O>3,working!E:E))}
Yet this doesn't: {=MEDIAN(IF(working!O:O<4,working!E:E))}
And yes, there are results that meet that IF requirement. Workbook is attached. Help is appreciated.
Bookmarks