#SPILL!
A formula returns multiple values but cannot write them out.
What it means
A dynamic array formula needs a block of empty cells to spill its results into. If anything blocks that block (data, a merged cell, the edge of the grid), the whole formula returns #SPILL! instead of a partial result.
How to fix it
- Clear the blocking cells (selecting the error usually outlines the blocked range).
- Move the formula somewhere with room to expand.
- Aggregate to a single value instead, e.g. =SUM(A1:A5).
Common causes
- A non-empty cell inside the spill range.
- Merged cells overlapping the spill range.
- The spill range would run past the edge of the grid.
- A spill inside a table, which cannot hold dynamic arrays.