HI

I want to do a count of a value if another value is displayed in
another column. Its basically if someone gets something correct, I
want to know how many times they have got a particular answer. So a 1
in a column means that person has got the answer right, then if they
have a 1 i want to count how many times they have got a certain answer
against that 1?

I.e THis is a very long list, with a number of people and I want to
get stats.

Column A Column B COlumn C Column D
Answer Person A Person B Person C

Milk 1
1 0
Coke 1 1
1
Orange 0 1
1
Orange 1 1
0
Coke 0 1
0
Milk 0
1 1
Milk 1
1 1
Milk 0
1 0

Therefore

Person A has 4 correct
Person B has them all correct (8)
Person C has 4 correct

I want to create a summary though:


Person A Person B
Person C
Milk 2
4 2
Coke 1
2 1
Orange 1
2 1
TOTAL 4
8 4

Can anyone help please?

Cheers

Rich