Forum Discussion
Solved
!SPILL error with SUMIFS formula
Hi All, we have 2 users who are using Office 365 version, they're both experiencing the issue with SPILL error with formula SUMIFS. I clicked on the the yellow exclamation mark next to the error (ce...
This only happens when using multi-cell references in arguments of functions which normally expect a single value. IMO this is a bug with DA Excel when it opens files created in non-DA Excel, it should have inserted the @ operator in front of the cell arguments where a single value is expected.
I guess the question is how to interpret "normally expected". For example, if complicate the formula a bit
=SUM(SUMIFS(B:B,A:A,{"a";"b"}))it shall not be converted with implicit intersection sign.