Spill Error

Copper Contributor

How do I get rid of a "spill error" in excel?  I can't see a blocked cell but I can't get it to add the cells I put in the formula.

1 Reply

@skgoodyear 

 

Hard to say without a bit more info. The "Spill error" occurs when the function in question produces an array--a set of rows and columns--but there's insufficient space to display the full result. So without knowing more, it's hard to tell you more. You know the function, you know the data source, you have at least some concept of what the result should be...there has to be at least one occupied cell in the region required to display the full result. It could be some content that is not visible (like a single space), or a formula that right now is producing a blank space.......