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"
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.