Dealing with NaN values when compressing matrix

I have 1000 by 1000 matrix and i want to convert it into a 10x10 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

Answer 1

[Ameer Hamza]

You can pass omitnan to mean() to ignore NaN values

mean(x, 'all', 'omitnan')

[Ahmed Abdulla]

Thank you, i just read about this on the mean documnetation and it worked!