Hi there,
I'm trying to average column that only contain number (and ignoring zero) but I still dont get the right formula.
I tried with (=average(if(ISANUMBER(A1:A10000),A1:A10000))) but it doesn't work.
Here is the table.
<tbody>
</tbody>
I hope there is a way!!
PLEASE HELP!!
Regards,
JaretAleb
I'm trying to average column that only contain number (and ignoring zero) but I still dont get the right formula.
I tried with (=average(if(ISANUMBER(A1:A10000),A1:A10000))) but it doesn't work.
Here is the table.
A | 12-Dec-18 | X | A | 11-Mar-19 | ABC | 89 | 0 | B | 5-Apr-19 | X | B | 14-May-19 | B | 39 |
<tbody>
</tbody>
I hope there is a way!!
PLEASE HELP!!
Regards,
JaretAleb