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?

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

May work for you.

smoutsat wrote:
>
> 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

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

"Dave Peterson" wrote:

> =sumproduct(--(t3:aw3=t4:aw4))
>
> May work for you.
>
> smoutsat wrote:
> >
> > 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() likes to work with numbers.

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



smoutsat wrote:
>
> Thank you, Dave! Yes, that works but, what does the -- mean for future
> reference?
>
> "Dave Peterson" wrote:
>
> > =sumproduct(--(t3:aw3=t4:aw4))
> >
> > May work for you.
> >
> > smoutsat wrote:
> > >
> > > 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
> >

--

Dave Peterson

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

"Dave Peterson" wrote:

> =sumproduct() likes to work with numbers.
>
> The -- stuff converts trues to 1's and Falses to 0's.
>
>
>
> smoutsat wrote:
> >
> > Thank you, Dave! Yes, that works but, what does the -- mean for future
> > reference?
> >
> > "Dave Peterson" wrote:
> >
> > > =sumproduct(--(t3:aw3=t4:aw4))
> > >
> > > May work for you.
> > >
> > > smoutsat wrote:
> > > >
> > > > 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
> > >
>
> --
>
> Dave Peterson
>