Formula To Average Cells With Data Versus Blank Cells In The Same Column

[TMILJVIPM]

I need help with a formula for example: Cell M5 needs to give me an average of cells with data in them versus blank cells from M7:M17. Also in the M7:M17 range each cell has a formula.


Thanks in advance or the help.

 

[horrellbt01]

In your formula, if it is returning a blank is it an actual blank or a zero?

 

[TMILJVIPM]

In your formula, if it is returning a blank is it an actual blank or a zero?

the formula returns:100%
here is the formula for one of the cells: =IF(H7>0,100%,"")

 

[horrellbt01]

So the values in M7 through M17 are either "" or 100%?

 

[horrellbt01]

So if I understand you correctly.
You need an average of only the cells that have a value in them.

So for your example.
Lets say M7:M17 had 9 values and 2 blanks

You would want the formula to show 82% correct?

If so you are looking for the following:
=AVERAGEA(M7:M17)

 

[TMILJVIPM]

Yes that was it........thank you