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

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

      Dzung Vu , glad to know you sorted this out

  • Dzung Vu's avatar
    Dzung Vu
    Copper Contributor
    Jan 21, 2020

    SergeiBaklan 

    Thank you Sergei, I have passed the link to the users, they will let me know.

     

    Cheers

Resources