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