Hi!

One way:

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=AVERAGE(IF(B1:B5<0,B1:B5))

Biff

"Dana" wrote in message
...
A column of monthly totals
Jan 400
Feb 800
Mar 0
Apr 0
May 0
Need a simple formula that will return an average on non zero months ie:
600