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

JKPieterse

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.

MichaelBag

Copper Contributor

Aug 18, 2020

placing a Sum formula around the original sumifs does not work with this SergeiBaklan . Wonder if anyone can assist? SUMIFS($U$5:$U$35,Y1,$V$5:$V$35)

I have formulas that simply no longer work. If they wanted a new feature, introduce a new feature...do not break the tried and true methods. Wasted an hour hunting through help forums for no advancement other than to confirm its a microsoft change. Feels like a serious bug to me.