CSE array?

[2terangiwhiu]

Hi

i need some help with my CSE array attempt. I need to explain my problem

i have two columns in my spreadsheet (there are others) one column is colours and another is numbers.

I'm wanting to work out the median for a list of numbers that correlate with the colour brown - done this and it works as follows

=MEDIAN(IF(V$17:V$500="Brown",S$17:S$500))

i also want the median for the numbers in the same list which are NOT brown.

so why does neither of these work,

=MEDIAN(IF(NOT(W$17:W$500="Brown"),S$17:S$500)) OR

=MEDIAN(IF(V$17:V$500<>"Brown",S$17:S$500))

i hope this makes sense and i certainly appreciate any assistance

thanks.

 

[mikerickson]

They worked for me. Did you enter them with CSE?

Perhaps
=MEDIAN(IF(V$17:V$500="Brown", "", S$17:S$500))

 

[2terangiwhiu]

thanks Mike

i am using CSE

The positive seems to work, its when i try to qualify by saying NOT, eg <>"Brown" that I get a zero [/B]return value. also some of the cells are empty.