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

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,

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
  Diamond Contributor
  Jan 23, 2020
  Patrick2788
  
  Actually that is also dynamic array
  - Patrick2788
    Silver Contributor
    Jan 23, 2020
    SergeiBaklan
    To be clear, not FILTER, SEQUENCE, RANDARRAY, UNIQUE, etc.
SergeiBaklan
Diamond Contributor
Jan 23, 2020
Dzung Vu , glad to know you sorted this out