G
Guest
I need to average the figures in several cells. However some cells have a 0
in them.
I therefore want the formula to ignore the cells which have a zero.
I have used the AVERAGE & AVERAGEA function, but both count 0 cells.
(although AVERAGEA ignores blank cells, I need to keep the 0s in as they are
linked to another formula)
Thanks.
in them.
I therefore want the formula to ignore the cells which have a zero.
I have used the AVERAGE & AVERAGEA function, but both count 0 cells.
(although AVERAGEA ignores blank cells, I need to keep the 0s in as they are
linked to another formula)
Thanks.