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?
|