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...
- so maybe the original formula you wanted was:
=ROWS(Colorado)-COUNTA(Colorado[Description]) & " REG NEEDED"
or could be:
=COUNTBLANK(Colorado[Description]) & " REG NEEDED"
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"- so maybe the original formula you wanted was:
=ROWS(Colorado)-COUNTA(Colorado[Description]) & " REG NEEDED"
or could be:
=COUNTBLANK(Colorado[Description]) & " REG NEEDED"
