Thread
:
sumif - if the text has LCI in it
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Jay[_6_]
external usenet poster
Posts: 1
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.
Reply With Quote
Jay[_6_]
View Public Profile
Find all posts by Jay[_6_]