COUNT within an Array

  • Thread starter Thread starter MathewS
  • Start date Start date
M

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}
 
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<>""))
 
Sorry for the confusion. I simplified the formula, too
much. Try this...
{=COUNT(A3:A20=1)*(B3:B20=1)*C3:C20}
 
Back
Top