Average of different cells ignoring blanks
On 5/15/2018 10:44 AM, Craig Pyle wrote:
Hi
I am struggling to get averages of multiple cells on a sheet (not in
a range) whilst ignoring blank cells.
Try again; see if link to poster's Q? not broke this time--
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
Same true for the alternate sheets; presuming the number/name is fixed,
then just use 3D reference and go on...not, perhaps, the best way to
organize the workbook, but we don't have enough info to be able to help
in that regards.
--
|