What is the best route to get the sum of the number of calculated fields with a specific result?

I have 200 calculation fields that calculate (based off of a different table record) either a "+", an "O", or a letter.

I want to calculate the number of "+" results, the number of "O" results, and the number of neither "+" nor "O" results. Can I use a count function on a calculated field? Can I use an ExecuteSQL?

If you really want to go with keeping all fields in one record I guess your best chances are to add calculation fields:

ValueCount ( FilterValues ( List ( AnswerField1 ; AnswerField2; AnswerField3; [197 more...] ) ; "+" ) )

This will return the total amount of + answers, you can do the same for O. The last one depends on the answers that could possible filled in or you could go with calculation total amount of answer fields minus the two results you already have. This will however also count empty fields.

It will work, but it is very brittle design.