Counting values lower then the median.
 

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?

Counting values lower then the median.
 

Try...

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

Hope this helps!

In article .com,
wrote:

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?

Counting values lower then the median.
 

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



wrote in message
oups.com...
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?

Counting values lower then the median.
 

This works for me:

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

Counting values lower then the median.
 

I wrote:

This works for me:

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

But the other solution is much neater.... :-)