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

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

DiegoAlves_0-1682529371806.png

 

Reference of the matrix instead of the values contained

DiegoAlves_1-1682529496509.png

 

Version:

DiegoAlves_2-1682529671419.png

 

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)