software

Hello all!
I need help on writing a CountIF statement for the following: I want a total
count of serial numbers in column B that have discontinue in column E.
Try this array formula:

=SUM(IF((E1:E100=quot;discontinuequot;)*(B1:B100gt;0),1))

entered using SHIFT CTRL ENTER

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=496219The SUMPRODUCT worked. Thanks Elkar!

quot;Elkarquot; wrote:

gt; Depending on your needs, there are a couple different solutions he
gt;
gt; Use this first one if you just want a count of how many times quot;discontinuequot;
gt; appears in column E.
gt;
gt; =COUNTIF(E1:E100,quot;discontinuequot;)
gt;
gt; Use this second one if you want a count of lines in which both a serial
gt; number appears in column B and quot;discontinuequot; appears in column E.
gt;
gt; =SUMPRODUCT(--(B1:B100lt;gt;quot;quot;),--(E1:E100=quot;discontinuequot;))
gt;
gt; And of course, adjust the cell references to your needs. I just assumed
gt; rows 1 through 100 for the examples.
gt;
gt; HTH,
gt; Elkar
gt;
gt; quot;Tracyquot; wrote:
gt;
gt; gt; Hello all!
gt; gt; I need help on writing a CountIF statement for the following: I want a total
gt; gt; count of serial numbers in column B that have discontinue in column E.
gt; gt;

Depending on your needs, there are a couple different solutions he

Use this first one if you just want a count of how many times quot;discontinuequot;
appears in column E.

=COUNTIF(E1:E100,quot;discontinuequot;)

Use this second one if you want a count of lines in which both a serial
number appears in column B and quot;discontinuequot; appears in column E.

=SUMPRODUCT(--(B1:B100lt;gt;quot;quot;),--(E1:E100=quot;discontinuequot;))

And of course, adjust the cell references to your needs. I just assumed
rows 1 through 100 for the examples.

HTH,
Elkar

quot;Tracyquot; wrote:

gt; Hello all!
gt; I need help on writing a CountIF statement for the following: I want a total
gt; count of serial numbers in column B that have discontinue in column E.
gt;