software

What am I doing wrong?

=COUNTIF(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))

thanks
Hi!

Countif doesn't work that way.

Try this:

=SUMPRODUCT(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))

Biff

quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
...
gt; What am I doing wrong?
gt;
gt; =COUNTIF(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))
gt;
gt; thanks
gt;
That will count the number of times an quot;Hquot; appears in the second list, when
the corresponding $I$1 is in the first list?quot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; Countif doesn't work that way.
gt;
gt; Try this:
gt;
gt; =SUMPRODUCT(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))
gt;
gt; Biff
gt;
gt; quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
gt; ...
gt;gt; What am I doing wrong?
gt;gt;
gt;gt; =COUNTIF(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))
gt;gt;
gt;gt; thanks
gt;gt;
gt;
gt;
gt; That will count the number of times an quot;Hquot; appears in the second list,
gt; when the corresponding $I$1 is in the first list?

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

Biff

quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
...
gt; That will count the number of times an quot;Hquot; appears in the second list,
gt; when the corresponding $I$1 is in the first list?
gt;
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; Hi!
gt;gt;
gt;gt; Countif doesn't work that way.
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; =SUMPRODUCT(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
gt;gt; ...
gt;gt;gt; What am I doing wrong?
gt;gt;gt;
gt;gt;gt; =COUNTIF(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))
gt;gt;gt;
gt;gt;gt; thanks
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
It will. What is it you want to achieve?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
...
gt; That will count the number of times an quot;Hquot; appears in the second list,
when
gt; the corresponding $I$1 is in the first list?
gt;
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt; gt; Hi!
gt; gt;
gt; gt; Countif doesn't work that way.
gt; gt;
gt; gt; Try this:
gt; gt;
gt; gt; =SUMPRODUCT(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))
gt; gt;
gt; gt; Biff
gt; gt;
gt; gt; quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
gt; gt; ...
gt; gt;gt; What am I doing wrong?
gt; gt;gt;
gt; gt;gt; =COUNTIF(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))
gt; gt;gt;
gt; gt;gt; thanks
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;
perfect, that is what I was what to do.

The quot;PRODUCTquot; 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

quot;Bob Phillipsquot; gt; wrote in message
...
gt; It will. What is it you want to achieve?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
gt; ...
gt;gt; That will count the number of times an quot;Hquot; appears in the second list,
gt; when
gt;gt; the corresponding $I$1 is in the first list?
gt;gt;
gt;gt;
gt;gt; quot;Biffquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi!
gt;gt; gt;
gt;gt; gt; Countif doesn't work that way.
gt;gt; gt;
gt;gt; gt; Try this:
gt;gt; gt;
gt;gt; gt; =SUMPRODUCT(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))
gt;gt; gt;
gt;gt; gt; Biff
gt;gt; gt;
gt;gt; gt; quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; What am I doing wrong?
gt;gt; gt;gt;
gt;gt; gt;gt; =COUNTIF(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))
gt;gt; gt;gt;
gt;gt; gt;gt; thanks
gt;gt; gt;gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;
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 www.xldynamic.com/source/xld.SUMPRODUCT.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
...
gt; perfect, that is what I was what to do.
gt;
gt; The quot;PRODUCTquot; part of SUMPRODUCT() threw me off, I was thinking of product
gt; in the mathmatical sense and was concerned that something was going to get
gt; multiplied. Hence the question. You guys have been MOST helpful.
gt;
gt; Thank You, Bob and Biff
gt;
gt; quot;Bob Phillipsquot; gt; wrote in message
gt; ...
gt; gt; It will. What is it you want to achieve?
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
gt; gt; ...
gt; gt;gt; That will count the number of times an quot;Hquot; appears in the second list,
gt; gt; when
gt; gt;gt; the corresponding $I$1 is in the first list?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Biffquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi!
gt; gt;gt; gt;
gt; gt;gt; gt; Countif doesn't work that way.
gt; gt;gt; gt;
gt; gt;gt; gt; Try this:
gt; gt;gt; gt;
gt; gt;gt; gt; =SUMPRODUCT(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))
gt; gt;gt; gt;
gt; gt;gt; gt; Biff
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
gt; gt;gt; gt; ...
gt; gt;gt; gt;gt; What am I doing wrong?
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; =COUNTIF(--('Pilot 1'!H12:H24=$I$1),--('Pilot 1'!AA12:AA24=quot;Hquot;))
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; thanks
gt; gt;gt; gt;gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;