Forum Discussion

Dzung Vu's avatar
Dzung Vu
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
Dzung Vu's avatar
Dzung Vu
Copper Contributor
Jan 22, 2020

Hi SergeiBaklan 

Thanks for the help and link. They tried SUMIFS with one cell then copy for the whole range, it worked.

 

Best Regards,

Dz

 

Patrick2788's avatar
Patrick2788
Silver Contributor
Jan 23, 2020

Dzung Vu 

For those interested.  It doesn't take  much to produce a SPILL error.  You don't need to use a dynamic array to get the error.

 

It could be something as simple as this:

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 23, 2020

    Patrick2788 

    Actually that is also dynamic array

    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Jan 23, 2020

      SergeiBaklan 

      To be clear, not FILTER, SEQUENCE, RANDARRAY, UNIQUE, etc.

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Jan 23, 2020
        It does not take one of the new functions to make a formula spill, any formula which returns more than a single result will spill, regardless of the functions used

Resources