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!D8:D1026))))