IF Statement: CountIF statement

[Tracy]

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.

[pinmaster]

Try this array formula:

=SUM(IF((E1:E100="discontinue")*(B1:B100>0),1))

entered using SHIFT+CTRL+ENTER

HTH
JG

[Tracy]

The SUMPRODUCT worked. Thanks Elkar!

"Elkar" wrote:

> Depending on your needs, there are a couple different solutions here:
>
> Use this first one if you just want a count of how many times "discontinue"
> appears in column E.
>
> =COUNTIF(E1:E100,"discontinue")
>
> Use this second one if you want a count of lines in which both a serial
> number appears in column B and "discontinue" appears in column E.
>
> =SUMPRODUCT(--(B1:B100<>""),--(E1:E100="discontinue"))
>
> And of course, adjust the cell references to your needs. I just assumed
> rows 1 through 100 for the examples.
>
> HTH,
> Elkar
>
> "Tracy" wrote:
>
> > 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.
> >

[Elkar]

Depending on your needs, there are a couple different solutions here:

Use this first one if you just want a count of how many times "discontinue"
appears in column E.

=COUNTIF(E1:E100,"discontinue")

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

=SUMPRODUCT(--(B1:B100<>""),--(E1:E100="discontinue"))

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

HTH,
Elkar

"Tracy" wrote:

> 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.
>