Using Multiple Condition in Array Formula using "AND"?

  • Thread starter Thread starter Ptop
  • Start date Start date
P

Ptop

Is it possible to use more than one condition in an array
formula using "AND", the following does not return the
value, but defaults as if condition are false.

{=SUM(IF(AND(Test!$O$1:$O$5000="Closed",Test!
$A$1:$A$5000="Active"),Test!$Q$1:$Q$5000,0))}
 
One possible way

=SUMPRODUCT(--(Test!$O$1:$O$5000="Closed"),--(Test!$A$1:$A$5000="Active"),Te
st!$Q$1:$Q$5000)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

Ignore duplicates 4
conditional sum - number of arguments problem 4
Formula Issue 2
MedianIf multiple range and criteria 5
nested IF without repeating the condition? 1
Formula issue 9
How can I use the * wildcard in an array formula 4
Ms Excel Multiple Logical Test Function 0

Back
Top