Comparing data intervals

[smoutsat]

If 2 observers collected data, what formula would be needed to count the
total number of intervals (potentially 30 intervals) observer 1 agreed with
observer 2.

Observer 1 will enter data (1-5) on row 3 (cells T3-AW3)
Observer 2 will enter data (1-5) on row 4 (cells T4-AW4)

In other words, how many times does T3=T4, does U3=U4, etc.? Is there a
short formula to use without having to identify all 30 intervals?

 

[Dave Peterson]

=sumproduct(--(t3:aw3=t4:aw4))

May work for you.

If 2 observers collected data, what formula would be needed to count the
total number of intervals (potentially 30 intervals) observer 1 agreed with
observer 2.

Observer 1 will enter data (1-5) on row 3 (cells T3-AW3)
Observer 2 will enter data (1-5) on row 4 (cells T4-AW4)

In other words, how many times does T3=T4, does U3=U4, etc.? Is there a
short formula to use without having to identify all 30 intervals?

 

[smoutsat]

Thank you, Dave! Yes, that works but, what does the -- mean for future
reference?

 

[Dave Peterson]

=sumproduct() likes to work with numbers.

The -- stuff converts trues to 1's and Falses to 0's.

 

[smoutsat]

Thank you for explaining it! I appreciate your time today!