Thread: Running Average
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Running Average

=AVERAGE(IF(C1:C52<0,C1:C52))

HTH
Kostis Vezerides