I am trying to create a survey. And the survey has 4 options for each question A B C D.

For A its 1, B is 2, C is 3, and D is 4. Each is summed for a total across all the fields in a record giving a total for each record.

What I want to do now is count the number of As, Bs, Cs and Ds across the record and I can’t seem to do that ;-(

Should be something like sum if Field 1 = 1 and Filed 2 = 1 and Field 3 =1 …

And then another with Sum if Field 1 = 2 and Filed 2 = 2 and Field 3 =2 …

And so on for each record so I get the total number of A, B, C and D.

But I cant seem to do that does anyone have any idea how I can do this?

Thanks in advance