OK. So now I tried to sumproduct two other columns using the same
formula...and changing the column letters to match the new count I am looking
for - but it always returns a zero even though there is data there.
I want to find how many kids in each district have been evaluated for OI,
OHI, TBI, and Autism.
The District names (like "Camas") are in column E, rows 2 through 200
The Categories (OI, OHI, etc) are in column J, rows 2 through 200
I tried =SUMPRODUCT((E2:E200="Camas")*(J2:J200="TBI"))
Didn't work.
Any suggestions?
Thanks

"Grams" wrote:

=SUMPRODUCT((E2:E200="Camas")*(H2:H200="S"))
Got this one to work...thanks for all your help.

"RagDyer" wrote:

Your formula is missing the operators.

You need either an asterisk between the arguments, as Ron suggested:

=SUMPRODUCT((E2:E200="Camas")*(H2:H200="Sonja Freitas"))

OR, the unary, as Alan suggested:

=SUMPRODUCT(--(E2:E200="Camas"),--(H2:H200="Sonja Freitas"))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Grams" wrote in message
...
Here is where my actually data is (range of both columns)
=SUMPRODUCT((E2:E200="Camas"),(H2:H200="Sonja Freitas"))

"Alan" wrote:

=SUMPRODUCT(--(E2:E8="Camas"),--(H2:H8="S"))
Adjust the ranges to suit. 'Camas' and 'S' can be put into cells whish
make
it easier, eg if you have 'Camas in A1 and 'S' in A2 then:-
=SUMPRODUCT(--(E2:E8=A1),--(H2:H8=A2))
To check 'Riddle', all you have to do is enter 'Riddle' into A1 and 'D'
or
whatever to see other results,
Regards,
Alan.
"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