software

I need the below formula to also sum quot;Closed / Noquot;, since column B contains
both entries. Not sure how/where to add it to this formula.=SUMPRODUCT(--(Overall!B8:B1026=quot;Closed /
Yesquot;),--(ISNUMBER(SEARCH(G11,Overall!D81026))))

One way:

=SUMPRODUCT(--ISNUMBER(MATCH(Overall!B8:B1026,{quot;Closed / Yesquot;,quot;Closed /
Noquot;},0)),--(ISNUMBER(SEARCH(G11,Overall!D81026))))

--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;roy.okinawaquot; gt; wrote in message
...
gt; I need the below formula to also sum quot;Closed / Noquot;, since column B
contains
gt; both entries. Not sure how/where to add it to this formula.
gt;
gt;
gt; =SUMPRODUCT(--(Overall!B8:B1026=quot;Closed /
gt; Yesquot;),--(ISNUMBER(SEARCH(G11,Overall!D81026))))
Thanks again.

quot;Maxquot; wrote:

gt; One way:
gt;
gt; =SUMPRODUCT(--ISNUMBER(MATCH(Overall!B8:B1026,{quot;Closed / Yesquot;,quot;Closed /
gt; Noquot;},0)),--(ISNUMBER(SEARCH(G11,Overall!D81026))))
gt;
gt; --
gt; Rgds
gt; Max
gt; xl 97
gt; ---
gt; Singapore, GMT 8
gt; xdemechanik
gt; savefile.com/projects/236895
gt; --
gt; quot;roy.okinawaquot; gt; wrote in message
gt; ...
gt; gt; I need the below formula to also sum quot;Closed / Noquot;, since column B
gt; contains
gt; gt; both entries. Not sure how/where to add it to this formula.
gt; gt;
gt; gt;
gt; gt; =SUMPRODUCT(--(Overall!B8:B1026=quot;Closed /
gt; gt; Yesquot;),--(ISNUMBER(SEARCH(G11,Overall!D81026))))
gt;
gt;
gt;

You're welcome, Roy !
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;roy.okinawaquot; gt; wrote in message
...
gt; Thanks again.