SUMPRODUCT with OR condition

[DaveTurton]

I am trying to put an OR condition within a SUMPRODUCT formula but failing.


I've had a search though the forum and although some things are close, I can't find exactly what I am looking for


I am currently trying the below

=SUMPRODUCT(--(Enquiries!I$1:I$6000=Summary!J12),--(OR(Enquiries!F$1:F$6000="deferred",Enquiries!F$1:F$6000="removed")))

Basically I want to count the number of occurrences where column I on the Enquiries sheet matches cell J12 on the Summary sheet and column F on the enquiries sheet = either deferred or removed


Any help would be appreciated


Thank you

 

[shrivallabha]

Dave,


You can use:


=SUMPRODUCT(--(Enquiries!I$1:I$6000=Summary!J12),--((Enquiries!F$1:F$6000="deferred")+(Enquiries!F$1:F$6000="removed")))


Or


=SUMPRODUCT((Enquiries!I$1:I$6000=Summary!J12)*(Enquiries!F$1:F$6000={"deferred","removed"}))


PS: The formulas are untested so please check for missing / extra brackets.

 

[DaveTurton]

Great, Thank you