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))))
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))))
One way:
=SUMPRODUCT(--ISNUMBER(MATCH(Overall!B8:B1026,{"Closed / Yes","Closed /
No"},0)),--(ISNUMBER(SEARCH(G11,Overall!D8:D1026))))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"roy.okinawa" <[email protected]> wrote in message
news:[email protected]...
> 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))))
Thanks again.
"Max" wrote:
> One way:
>
> =SUMPRODUCT(--ISNUMBER(MATCH(Overall!B8:B1026,{"Closed / Yes","Closed /
> No"},0)),--(ISNUMBER(SEARCH(G11,Overall!D8:D1026))))
>
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
> "roy.okinawa" <[email protected]> wrote in message
> news:[email protected]...
> > 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))))
>
>
>
You're welcome, Roy !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"roy.okinawa" <[email protected]> wrote in message
news:[email protected]...
> Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks