Sum multiple text

[Guest]

I need the below formula to also sum "Closed / No", since column B contains
both entries. Not sure how/where to add it to this formula.


=SUMPRODUCT(--(Overall!B8:B1026="Closed /
Yes"),--(ISNUMBER(SEARCH(G11,Overall!D81026))))

 

[Max]

One way:

=SUMPRODUCT(--ISNUMBER(MATCH(Overall!B8:B1026,{"Closed / Yes","Closed /
No"},0)),--(ISNUMBER(SEARCH(G11,Overall!D81026))))

 

[Guest]

Thanks again.

One way:

=SUMPRODUCT(--ISNUMBER(MATCH(Overall!B8:B1026,{"Closed / Yes","Closed /
No"},0)),--(ISNUMBER(SEARCH(G11,Overall!D81026))))

 

[Max]

You're welcome, Roy !