Hi,
I have a formula
=AVERAGEIF(H99:H111,">0",H99:H111)
Some of the answers are returning the error #DIV/0! due to there being no figures in what is being averaged, however it is a big table and I don't want to have to do individual formula's to get rid of the error.
How can I get rid of the error, while still making this formula work?
Cheers,
I have a formula
=AVERAGEIF(H99:H111,">0",H99:H111)
Some of the answers are returning the error #DIV/0! due to there being no figures in what is being averaged, however it is a big table and I don't want to have to do individual formula's to get rid of the error.
How can I get rid of the error, while still making this formula work?
Cheers,