Thread: Median If in Excel not working
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
  
Posts: 829
Default Median If in Excel not working
"Claus Busch" wrote:
try:
=SUMIF(I2:I50,"<"&$M$1,J2:J50)/COUNTIF(I2:I50,"<"&$M$1)

That is the mean (average), not the median.
Reply With QuoteReply With Quote