COUNT within an Array

[MathewS]

I am try to get a Count of non empty cells in a range
(U3:U20), based on two criteria in two other ranges. I am
getting a resust of zero which is not correct. Any help??

{=COUNT(A3:A20=1)*(A3:A20=1)*U3:U20}

 

[Laura Cook]

I am a little confused by the two criteria being the same, maybe you made an
error in you message?

Anyhow, below is an example of using multiple criteria to get a count:

=SUMPRODUCT((A3:A20=1)*(C3:C20="No")*(U3:U20<>""))

 

[MathewS]

Sorry for the confusion. I simplified the formula, too
much. Try this...
{=COUNT(A3:A20=1)*(B3:B20=1)*C3:C20}

 

[Laura Cook]

Try the following:

=SUMPRODUCT((A3:A20=1)*(B3:B20=1)*(C3:C20<>""))

 

[MathewS]

That worked. Thanks very much!

(funny, you'd think COUNT would do it!?!)