SPILL Erorr causing all kinds of errors

[mkingsle]

I'm creating a basic Excel doc to track some gift card balances, and in the first sheet I have the total with a formula to subtract deductions on another sheet from the total. When I do this in the first row, it creates the SPILL formula, and I can't edit, nor do I want it there. How do I remove this? 

If I can't remove this, how do I get the next row to be a different dataset?!

[#2]

I would suggest including the formula you are using (perhaps the workbook itself with any/all sensitive information removed or, if possible, an example of your workbook and formula using mock data).

I don't have dynamic arrays and don't expect to be able to help you find the issue, but you can assist the other respondents in providing a specific answer with more information that is specific to your situation.