Lookup possibly?
I have a matrix that records call types and whether the call was correct or
not.
See table below:
call1 call 2 call 3 call 4 Call 5
type 1 y y
type 2 y
type 3
type 4 y y
correct y n n y y
I need a function or something that will find the number of calls that are
type 1 and then count the number that are correct. Then to do the same for
type 2 to 4.
Is this clear? I hope so.
E.g. the answers I want to get are below.
No. No. correct
Type 1 2 1
Type 2 1 0
Type 3 0 0
Type 4 2 2
Any help would be much appreciated.
|