ExcelBanter - sumif - if the text has LCI in it

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

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

- - sumif - if the text has LCI in it (https://www.excelbanter.com/excel-worksheet-functions/230344-sumif-if-text-has-lci.html)

Jay[_6_]

sumif - if the text has LCI in it

I have long texts in rows of column A and values in Column B. The
sheet has 1000 rows.
I want to add values in column B if the texts has "LCI" in it. I
tried sumif(A1:A1000,"LCI",B1:B1000), but gives value 0.

Jacob Skaria

sumif - if the text has LCI in it

You are almost close. Try this

=SUMIF(A1:A1000,"*LCI*",B1:B1000)

If this post helps click Yes
---------------
Jacob Skaria

"Jay" wrote:

I have long texts in rows of column A and values in Column B. The
sheet has 1000 rows.
I want to add values in column B if the texts has "LCI" in it. I
tried sumif(A1:A1000,"LCI",B1:B1000), but gives value 0.

Ashish Mathur[_2_]

sumif - if the text has LCI in it

Hi,

you may also try this.

=SUMPRODUCT((ISNUMBER(SEARCH("LCI",A2:A1000,1))*(B 2:B1000)))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jay" wrote in message
...
I have long texts in rows of column A and values in Column B. The
sheet has 1000 rows.
I want to add values in column B if the texts has "LCI" in it. I
tried sumif(A1:A1000,"LCI",B1:B1000), but gives value 0.

All times are GMT +1. The time now is 12:41 PM.