Forum Discussion
Sumif showing #value error after update
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.
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)
