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"
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"
=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"
=ROWS(Colorado)-COUNTA(Colorado[Description]) & " REG NEEDED"
or could be:
=COUNTBLANK(Colorado[Description]) & " REG NEEDED"