View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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?