HELP! I need to average a colum of numbers omiting zero values, I found the
formula in the help menu and copied it using my cell ranges when I try to
enter formula it returns an error message with the false value highlighted
this is my formula:
=AVERAGE(IF(d5:d32<0,d5:d32,**)) it will not accept the ** as a false value.
If I can get past this I also need to find a min. value with zero values
omited.