What am I doing wrong?

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

thanks

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

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

That will count the number of times an "H" appears in the second list,
when the corresponding $I$1 is in the first list?

Yes. That's what you wanted, isn't it?

Biff

"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

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

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

Something is getting multiplied. The arrays that result from each
conditional test are multiplied, and then the resultant array is summed.
Take a look at http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
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