Thread: Counting values lower then the median.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Lincoln
 
Posts: n/a
Default 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.... :-)

Reply With QuoteReply With Quote