Thread: MEDIAN, STDEV of a range IF another range = specific value
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default MEDIAN, STDEV of a range IF another range = specific value
Try...

=MEDIAN(IF(D$2:D$107=D111,IF(F$2:Q$107<"",F$2:Q$1 07)))

Hope this helps!

In article ,
Barb Reinhardt wrote:

I have cells in F2:Q107 that are blank and the calculations appear to treat
those as zeros. What needs to be changed.
Reply With QuoteReply With Quote