YTD average - How do I create a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...

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.
 
Back
Top