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.

--

Hello! from what I know, Average ignores blank cells, so you just have to go run the average function and the values you want to average, and you should be okay.

I learned many things about the average function in excel he
https://www.efinancialmodels.com/kno...rage-function/

Hope this helps!