On Wednesday, 16 May 2018 03:44:23 UTC+12, Craig Pyle wrote:
Hi

I am struggling to get averages of multiple cells on a sheet (not in a range) whilst ignoring blank cells.

Can anyone assist please?

Excel is not very friendly when you start splitting your data into multiple tables. I would make a "Totals" sheets where I collect the sums and counts from each sheet. You can then calculate the overall averages from these.