Help Can it be done? I am confused?

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

 

[Frank Kabel]

Hi
try something like
=COUNTIF(OFFSET($A$1:$F$1,MATCH("type1",A2:A5,0),0),"y")