Count if all both apply
With your posted data in A1:B8
And:
C1: (a District...eg Camas)
D1: (a Teachre..eg S)
This formula returns the count of Camas/S combinations:
E1: =SUMPRODUCT((A2:A10=C1)*(B2:B10=D1))
Is that something you can work with?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"Grams" wrote in message
...
I have a column (E) that contains names of districts, and column a column
(H)
that contains names of teachers and I need to summarize how many times a
certain teacher is connected to a district. Both columns have multiple
entries in both columns. What equation would I use to find out how many
times teacher S is listed with an entry of district C (in other words, if
the
district was Camas, how many times would teacher S show up connected to
that
district). Clear as mud, I'm sure
District Teacher
Camas S
Camas D
Camas P
Camas S
Riddle S
Riddle P
Camas S
My result should be 3
thanks in advance
|