I am trying to calculate the number of checked cells in a column (named 'Done'), however I keep getting errors!
The checked ('Done') column in question is pulling from another sheet using index links so will throw up a tick in the check box and a #NO MATCH accordingly.
The calculation i am using to pull from the checked column is: =COUNTIF(Done:Done, "1"). This will throw up #NO MATCH
Is there a way to ignore the #NO MATCH so the calculation works?
Thanks