Forum Discussion
SPILL ERROR CAUSING MORE WORK NOT REDUCING IT _ MAKE IT OPTIONAL!
In my opinion you screwed up your formula.
The part A12=... requires a single cell and not an array of cells. The correct form would have been:
=IF(A$12=A3,"Y","N")The reason why it still worked in old Excel is "implicit intersection".
In new Excel you have to explicit use the implicit intersection operator.
=@IF(A12=(A3:A8),"Y","N")Or just let the formula spill.
In my opinion you screwed up your formula.
The part A12=... requires a single cell and not an array of cells. The correct form would have been:
=IF(A$12=A3,"Y","N")
The reason why it still worked in old Excel is "implicit intersection".
In new Excel you have to explicit use the implicit intersection operator.
=@IF(A12=(A3:A8),"Y","N")
Or just let the formula spill.
Detlef_Lewin thank you so much for this. Using the @ worked in my SumIf and resolved the error I encountered. For those of us that didn't understand the change in Excel and what it was doing, your brief explanation below helps to clarify and will help with other formulas.
