ExcelBanter - Sum multiple text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sum multiple text (https://www.excelbanter.com/excel-worksheet-functions/61360-sum-multiple-text.html)

roy.okinawa

Sum multiple text

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

Max

Sum multiple text

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" wrote in message
...
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))))

roy.okinawa

Sum multiple text

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" wrote in message
...
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))))

Max

Sum multiple text

You're welcome, Roy !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"roy.okinawa" wrote in message
...
Thanks again.

All times are GMT +1. The time now is 04:18 AM.