Forum Discussion
Solved
#spill Error
Hello I have this function above a defined table
=ROW(Colorado)-1+COUNTA(Colorado[Description])
The Error states its a "Spill Range Isn't Blank" and when I select the Obstructing Cells its everything in the column I defined.
Is it because Its on in the table itself?
- so maybe the original formula you wanted was:
=ROWS(Colorado)-COUNTA(Colorado[Description]) & " REG NEEDED"
or could be:
=COUNTBLANK(Colorado[Description]) & " REG NEEDED"
8 Replies
- The problem is that ROW(Colorado) returns an array of values (each row of the table). If you wanted the total number of rows in the table you should use ROWS(). Maybe explain what that formula is SUPPOSED to do.
- Thanks that is much easier - appreciate the hint
- So now just need to figure how how to use the rows() function in place of my literals:
=COUNTBLANK($C$4:$C$31)& " REG NEEDED"
Your formula returns spill of the same size as table Colorado. If you have not enough space to place it that will be #SPILL error.
