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" Sorry, didn't catch, why do you need ROWS() here?
well instead of have the C2:C27 I wanted to use something like this
=COUNTBLANK(ROWS(Colorado[Regulatory Reference])) & " REG NEEDED"
but that isn't working I tried IS BLANK with the same and it doesn't work either.
I just wanted to make so I didn't have to check each tab for the number of rows and update it all manually as noted in red below
=COUNTIF(G4:G31,"TBD") & " TBD RESOLUTION NEEDED"
