Forum Discussion

Copper Contributor

Jan 20, 2020

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...

excel

Formulas and Functions

office 365

SergeiBaklan
Jan 20, 2020
Dzung Vu

It could be similar to https://techcommunity.microsoft.com/t5/excel/spill-error-when-doing-vlookup/m-p/1117822#M49530

SergeiBaklan

Diamond Contributor

Jan 20, 2020

Dzung Vu

That's the imitation of the case

Exactly the same formula. Pre-DA Excel returns 24 (since takes only first element of the array), DA Excel returns spill or #SPILL! error if it's not enough space for the spill.