Average of different cells ignoring blanks
Hi
I am struggling to get averages of multiple cells on a sheet (not in a
range) whilst ignoring blank cells.
Over what is the struggle?
AVERAGE() ignores blank cells automgically so that part's easy-peasy; if
the cell locations aren't contiguous, you just have to enumerate them in
the argument list.
--
|