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