Say In A1 thru B10 we have:

Krissy Sad
Krissy Sad
Krissy Sad
Krissy Happy
Krissy Happy
Debbi Happy
Debbi Happy
Debbi Sad
Debbi Sad
Debbi Sad

and we want to count the rows in which Krissy is Happy:

=SUMPRODUCT((A1:A10="Krissy")*(B1:B10="Happy"))
--
Gary''s Student - gsnu200909


"Krissy" wrote:

Hi
I need a formula that will look in one column range for a certain value and
for another value in another column range and when they are both found in the
same row, will count the number of occurances. Help!!!!