AND doesn't return array

L

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
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX return multiple columns 1
finding repeating numerical pattern using array functions? 0
Need help finding a substring in a array of strings. 1
Array function - I think! 8
Compressing multiple functions across an array into one cell 6
Vlookup and return sheet name also 2
Can UDF return a customized hyperlink? 3
Using SUM + INDEX in array formula 5

Top