Counting values lower then the median.

[googlegroups.zaphod]

Thank you in advance for any help anyone may be able to offer.

I have a list of numeric values in column A.

in B1 I use the function =median(A1:A150) to get the median value for
column A

In C1 I would like a count of the values in column A which are LOWER
then the Median value in B1

I tried using the =countif(A1:A150, < B1) but i get an error so that is
obviously not correct.

How do I get this count?

 

[Domenic]

Try...

=COUNTIF(A1:A150,"<"&B1)

Hope this helps!

 

[Peo Sjoblom]

=COUNTIF(A1:A150,"<"&B1)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Mark Lincoln]

This works for me:

=SUMPRODUCT(--(ISNUMBER(A1:A150)),--(A1:A150<B1))

 

[Mark Lincoln]

This works for me:

SUMPRODUCT(--(ISNUMBER(A1:A150)),--(A1:A150<B1))