Forum Discussion
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...
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.
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
- 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.