Sum multiple text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

roy.okinawa - 21 Dec 2005 01:55 GMT

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))))

Reply to this Message

Max - 21 Dec 2005 02:47 GMT

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
--

> 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))))

Reply to this Message

roy.okinawa - 21 Dec 2005 21:43 GMT

Thanks again.

> One way:
>
[quoted text clipped - 16 lines]
> > =SUMPRODUCT(--(Overall!B8:B1026="Closed /
> > Yes"),--(ISNUMBER(SEARCH(G11,Overall!D8:D1026))))

Reply to this Message

Max - 22 Dec 2005 01:06 GMT

You're welcome, Roy !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

> Thanks again.

Reply to this Message