| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF with text | Excel Worksheet Functions | |||
| SUMIF for Text | Excel Discussion (Misc queries) | |||
| Sumif vs Text? | Excel Worksheet Functions | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| sumif with text? | Excel Discussion (Misc queries) | |||
![Jay[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
