software

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

Hi!

One way:

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

=AVERAGE(IF(B1:B5lt;gt;0,B1:B5))

Biff

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

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

=SUMIF(A1:A4,quot;lt;gt;0quot;)/COUNTIF(A1:A4,quot;lt;gt;0quot;)

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