View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdeaston pdeaston is offline
external usenet poster
 
Posts: 1
Default Omitting zeroes when looking for minimum values

I have a spreadsheet where I track maximum and minimum values. The data is
entered daily, so I have formulas entered for the entire year. That means,
of course, that zero is the value for every day of the year beyond today.
How do I omit those in my calculation of minimum values?