Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Sumif showing #value error after update

Copper Contributor

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






Thanks for your attention.


1 Reply

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)