Formula getting updated in every cells automatically

[matzindergard]

Matz, kindly describe your issue:

I am trying to initiate a formula taken from Real Statistics, where an output is given as a matrix. However, when I initiate the formula, I receive an error in one cell (#VALUE!) and the matrix fails to form. I think I may have an issue with the spill ability in excel to populate an array with data from my formula. Any help would be greatly appreciated.

Formula used: 

=(MMULT(TRANSPOSE(B3:BH135-B137:BH137),B3:BH135-B137:BH137)/(COUNT(B3:B135)-1))

[#2]

@matzindergard 

Same question in the link below. Already answered.

https://techcommunity.microsoft.com/t5/excel/enable-autospill/m-p/2317760#M98534 

[#3]

@matzindergard 

As variant you have text (e.g. empty string) within B3:BH135 and/or B137:BH137