Spill Error...

I've never come across this before, and have no idea how to fix it, so apparently I need a better formula.

This formula gives me a "Spill" error in 1 cell only:

Please Login or Register  to view this content.

I have no idea what a spill error is, or how to get rid of it. I use formulas like this in other spreadsheets and have never had an issue.

Your help is much appreciated!

As it states in the formula, it is to find the row 7 above the current row in column 2 and subtract the value of the current row in column 2. And then it's wrapped in an iferror as the first 7 rows return an error because there aren't enough rows above it.

The cell that has the spill error should be 0 (see the pattern in column 3).

That does the job perfectly, thanks

I just adjusted it to take "$" out of the "$22" so that it will keep going as I add lines to the table.