Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup possibly?
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 -- Best Regards Leo Heuser Followup to newsgroup only please. "Bill L" skrev i en meddelelse ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |