Forum Discussion

Dzung Vu's avatar
Dzung Vu
Copper Contributor
Jan 19, 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
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
SWalter2937's avatar
SWalter2937
Brass Contributor
Feb 28, 2020

This "SPILL!" error is garbage, it is causing issues with code that worked fine and now is broken. Microsoft contines to build on reasons to change to Google, my spouse works for a major corporation that just announced they are dumping Microsoft and going to Google. I am starting to think the same thing, with O365 it is just way to easy for Microsoft to crash your data functions with update "improvement". JKPieterse 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Feb 28, 2020
    Hmm, but excel has had functions added in many versions and of course those wouldn't work on earlier ones. I would think that applies to any kind of software.
  • SWalter2937's avatar
    SWalter2937
    Brass Contributor
    Feb 28, 2020

    I don't even understand how you make the statement, "Backward Compatibility is very important to them you know". Have you met Xlookup, you know, the one that only works in O365 with ZERO backwards compatibility, even in Excel 2019? So it can't be used in an Org with mixed versions of Excel, at all, or anyone not on O365. 

     

    Excel desktop and Excel for the web aren't even really compatible at anything but the most basic level.

     

    I have been an Excel user since the 90s, I love using Excel, but the last year has been nothing but a series of issues and disappointments. JKPieterse 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Feb 28, 2020
    I'd rather you post an example of where things went wrong, so they might fix the problem. Backward Compatibility is very important to them you know.

Resources