Count formula & manual entry results, discluding N/A

[Fi_83]

I am trying to count a column that has test scores - I just want to know how many people sat an exam when filtered on another field (eg colour in my example).
Some of the scores in D are taken from a formula, and some manual entered
I do not want to include N/A errors in count


I cannot get this to work when filtering data - can anyone help?
I have tried
=SUBTOTAL(3,X:X)-COUNTIF(X:X,NA())
=SUM(IF(ISERROR(x:x),1))
=SUM(COUNTIF(x:x,{">0",""}))

 

[arthurbr]

Cross posted and reported

 

[Fluff]

Cross posted count filtered rows

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.