Thread: Median - Ignore blanks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jhicsupt jhicsupt is offline
external usenet poster
  
Posts: 25
Default Median - Ignore blanks
What is the formula to ignore blanks? In other words, there are some 0, so I
want to include the 0. However there are some blanks and I want to exclude
the blanks.

Thanks in advance.
Reply With QuoteReply With Quote