Excel dynamic arrays not able to be multiplied together
16:27 30 Nov 2025

I have two arrays that won't multiply together, I just get a single zero. I would expect the result to be an array.

Is there some behaviour of dynamic arrays that I don't understand here? The arrays are the same size

enter image description here

enter image description here

I had the same issue using the FILTER function but it seems like it is something related to the arrays themselves not the function I'm using.

As I understand how the two input arrays are generated shouldn't have any effect on multiplying them together.

arrays dynamic