Recently there was an update to my Windows and Office suite. After this update, I noticed that, for example, the Sumif function, although it works within the context of the function argument window, the result of the selected matrices started to appear as "#value!" or the reference of the matrix instead of the values contained in the matrix. I tested this with some friends and they are experiencing the same issue. Does anyone know if this is a known bug or if there is a way to resolve it?
Reference of the matrix instead of the values contained