Creating an Excel spreadsheet for an Attribute Gage study (AIAG MSA Rev4)

[qualitygeek]

In an attribute gage study I need to compare pass "1" or fail "0" agreement of three operators over multiple (3) measurements and can't figure out how to do it.
Operator A measures 50 parts 3 times, B and C do the same. Compare Operator A&B measurements 1, 2, 3 to see if they agree on the result of 1 or 0. Then I need to sum for each of the four possible outcomes A:B agree on "1", A:B disagree A=1, B=0, A:B disagree A=0, B=1, and A:B agree on "0". Any help or guidance would be appreciated.

[shg]

	O	P	Q	R	S	T
9		0	1	Totals
10	0	44	6	50		P10: =COUNTIFS($B$8:$D$57, $O10, $E$8:$G$57, P$9)
11	1	3	97	100
12	Totals	47	103

[qualitygeek]

Thank you for your help.
According to the published rules I need to mark the post as "solved". Any suggestions on how to do that??

[63falcondude]

To mark a thread as SOLVED, select Thread Tools from the menu link above and mark this thread as SOLVED.