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