"Dana" wrote:
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

If you don't like working with array formulas, you could do
the following:

=SUMIF(A1:A4,"<0")/COUNTIF(A1:A4,"<0")

But I wonder why you think ignoring zero months gives you
the YTD average.