View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill L[_3_] Bill L[_3_] is offline
external usenet poster
 
Posts: 1
Default 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.