Sumif showing #value error after update

[DiegoAlves]

Hello everyone,

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?

#Value!" error

Reference of the matrix instead of the values contained

Version:

Thanks for your attention.

[#2]

Hello @DiegoAlves 

On Mysterious #Value! notification in SUMIFS ranges Rich~M says the issue exists for months (true/false? no idea). Just checked and can repro - when ranges are on a different sheet - with v2304 Build 16327.20214 Current Channel

No idea if MS is aware. Probably a good idea to send a Frown (File > More > Feedback)