Lookup possibly?

B

Bill L

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.
 
L

Leo Heuser

Bill

One way:
Assuming your first list in A1:F7 (row 6 empty) and assuming
your second list in H1:J5:

In i2:
=COUNTA(B2:F2)

In J2:
=SUMPRODUCT((B2:F2="y")*($B$7:$F$7="y"))

Select i2:J2 and copy down to i5:J5
 
Top