That can be reduced to:

=SUM((E18:E35="SMOOTHING")*(K18:K35="JC"))

--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
Hi,

Although there is nothing really wrong with your formula, it should give
the
correct results, a better way to phrase it would be:

=SUM(IF((E18:E35="SMOOTHING")*(K18:K35="JC"),1,0))

Array entered.

If your formula is failing to return the correct results it is probably
because it isn't array entered Press Shift+Ctrl+Enter to enter it.

=COUNT(IF((E18:E35="SMOOTHING")*(K18:K35="JC"),0))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"skyflier" wrote:

Trying to count # of times these two conditions are met using formula
below
as an array. Answer always 0???

=COUNT(IF((E18:E35="SMOOTHING")*(K18:K35="JC"),0))


--
SkyFlier