Thread: Counting values lower then the median.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Lincoln
 
Posts: n/a
Default Counting values lower then the median.
This works for me:

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

Reply With QuoteReply With Quote