perfect, that is what I was what to do.

The "PRODUCT" part of SUMPRODUCT() threw me off, I was thinking of product
in the mathmatical sense and was concerned that something was going to get
multiplied. Hence the question. You guys have been MOST helpful.

Thank You, Bob and Biff

"Bob Phillips" wrote in message
...
It will. What is it you want to achieve?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
That will count the number of times an "H" appears in the second list,
when
the corresponding $I$1 is in the first list?


"Biff" wrote in message
...
Hi!

Countif doesn't work that way.

Try this:

=SUMPRODUCT(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24="H"))

Biff

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
What am I doing wrong?

=COUNTIF(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24="H"))

thanks