median if function

i'm using a 'median if' function to choose median value for certain regions. however, when i use this, its gives me the wrong number...example, if i have 7 numbers inthe range, instead of giving me the 4th, it gives me the third...i've double-checked my ranges and can't figure this out. any caveats for this function? (PS, i'm already confirming using Cntrl+Shift+Enter)...

J

i realize that. like i said, with a range of consecutive integers, say, 1-7, the median should be 4. 3 of the numbers are greater and 3 are lesser.

the interesting thing about my median if on this program is that it gives me the 3 number in the data range...