=COUNTIF(Active!C:C,"<>""")
For some reason the result is everyline in the column, I have tried "clear all" on the empty cells but to no joy.

Does anyone have any idea why this is happening.

Side issue I have used the below code to try to counter this and it only produces results on values with a date, anything with writing (i.e. "Yes", "No") isn't included in the count.

Again any ideas why?

=COUNTIF(Active!C:C,">0")