Calculate percentage without counting 0?

[Vihral]

Hi!

I have an excel file with 7 different cells which calculated an average % based on some other cells values.

2 things

I want those 7 cells to NOT count the 0% ones (Since that info has not yet been inserted) and then secondly I want a cell that calculated the %age from those 7 (Without the 0%'s since they have not been added yet).

Its based on a monthly statistic so next month ill start filling out cell number 2 and then the cell will calculate that result as well.

Hope this makes sense and its easy to do!

I tried a =countif(D14:X15, ">0")/COUNT(D14:X15) but that didnt work (Found it on a forum!, no idea what it does :P )

[daddylonglegs]

Which 7 cells, is that a range like A1:A7 or 7 separate cells? If it's the former then you can use a simple AVERAGE and blank cells will be ignored, e.g.

=AVERAGE(A1:A7)

If you actually have zeroes in the cells that you want to ignore then try AVERAGEIF

=AVERAGEIF(A1:A7,">0")

[Vihral]

I have Cells D-F Merged (14+15) (D14, G14,J14,M14,P14,S14,V14) (last cell is X15)

I tried both those but they both come back saying that the forumla I type contains an error.

Everything is % so for example G-X14 atm says 0,00% and the cells contains this: "=AVERAGE(M3:O10)" (<-- This is cell M14)

Any ideas? >.<