AnsweredAssumed Answered

counting values in a record

Question asked by jlcalhoun61 on Nov 14, 2018
Latest reply on Nov 14, 2018 by jlcalhoun61

I have a table that has 25 questions in it.  Each question field has a answer value in another field.  I am using the Count (field1;field2;field3...) to find the total number of answered questions, but I need to know the count of the questions that have an answer of "Defect Found" .  Is there a way to use the Count function or something else that will only count the values if it matches my filter text?

Outcomes