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
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:B5<>0,B1:B5))
Biff
"Dana" <[email protected]> wrote in message
news:[email protected]...
>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
"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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks