Thread: Average - without zero?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] cjwenngatz@gmail.com[_2_] is offline
external usenet poster
  
Posts: 16
Default Average - without zero?
On Feb 7, 9:06*am, Cliff wrote:
=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")

Thanks Cliff, that worked perfectly!
Reply With QuoteReply With Quote