MATLAB: Dealing with NaN values when compressing matrix

MATLABmatrixmatrix manipulation

I have 1000 by 1000 matrix and i want to convert it into a 10×10 matrix, ive found several way on the community that does this. However my matrices contain some cells that are NaN so when the all the values gets added to get averaged for compression the NaN cells force this calculation to yield NaN and so the compressed cell is equal to NaN.
for example if 10 cells are to be averaged and one of them is NaN, is there a way to make it add the 9 values and divide by 9 rather than 10

Best Answer

You can pass omitnan to mean() to ignore NaN values
mean(x, 'all', 'omitnan')