Thread: Average - without zero?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Cliff[_4_] Cliff[_4_] is offline
external usenet poster
  
Posts: 2
Default Average - without zero?

=AVERAGE(IF(B5:B17<0,B5:B17)) & enter this as an array formula via
Ctrl+Shift+Enter

or in Excel 2007

=AVERAGEIF(B5:B17,"<0")

Reply With QuoteReply With Quote