clarification ! the sample expression was names "Test A Totals". it should only return 2000. I have one for Test B and Test C and it's shortened accordingly
Test B Totals
COUNT([Test Procedure]='Test B')+COUNT([Test Procedure]='Test C') >>> returns 4000
Test C Totals
COUNT([Test Procedure]='Test C') >> returns 2000
Are the Tests all part of the same dimension? Are you able to post a sample workbook (twbx file) ?