BenF12345 wrote:
How do I find out how many times Group 1,2,3 used each test?
Using Excel 2000

A B C D E F
Group Test Group Test 1 Test 2 Test 3
1 Test 1 1
2 Test 3 2
3 Test 2 3
1 Test 1
2 Test 3
3 Test 3


Thanks!!!

In D2, then fill right and down. This is an array formula (commit with
Ctrl+Shift+Enter).

=SUM(($C2=$A$2:$A$7)*(D$1=$B$2:$B$7))