Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup possibly ? | Excel Worksheet Functions | |||
How can "=LOOKUP(I4,I2:I11)" POSSIBLY return #N/A?? | Excel Worksheet Functions | |||
Possibly an Array, but I'm not sure? | Excel Discussion (Misc queries) | |||
count if (possibly?!) | Excel Worksheet Functions | |||
Lookup possibly? | Excel Discussion (Misc queries) |