COUNTIF(--(),--()) help in '97

A

Adam Kroger

What am I doing wrong?

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

thanks
 
B

Biff

Hi!

Countif doesn't work that way.

Try this:

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

Biff
 
A

Adam Kroger

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

Biff

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

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

Biff
 
B

Bob Phillips

It will. What is it you want to achieve?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
A

Adam Kroger

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
 
Top