AND doesn't return array

[Lee]

I can't make AND function return an array, the formula is:
=SUM(IF(AND($A1:$A10000="y";$G1:$G10000="");1;0)) but the
result is always zero. I did some sipmle tests and it
seems to me, that AND function is unable to return array
of values. How to make this formula work.
Thanks a lot, Lee

 

[Don Guillett]

try this NON array entered formula
=SUMPRODUCT(($A3:$A10002="y")*($G3:$G10002=""))