Comparison Operators for IF statement.
Folks,
I am trying to see if I can use a wildcard character type to search for a textstring within an IF Statement. I know that I can do a filter to return the rows of a column that meets certain criteria (including "contains", "begins with", etc.): If(A1 = "CA*", a1+1,0) or Sumif(A1:A10,"CA*", c1:e1) Any insight will be greatly appreciated. Regards, Shams. |
Not sure what you're trying to do here.
If A1 starts with "CA", and is therefore text, why are you adding 1 (which will cause a #VALUE! error)??? Depending on what you're really trying to do, you might be able to use something like: =--(COUNTIF(A1,"CA*")0) to return 1 or 0. The SUMIF() should work fine if you make the criterion and sum ranges the same size: =SUMIF(A1:A10,"CA*",C1:C10) In article , "Shams" wrote: Folks, I am trying to see if I can use a wildcard character type to search for a textstring within an IF Statement. I know that I can do a filter to return the rows of a column that meets certain criteria (including "contains", "begins with", etc.): If(A1 = "CA*", a1+1,0) or Sumif(A1:A10,"CA*", c1:e1) Any insight will be greatly appreciated. Regards, Shams. |
All times are GMT +1. The time now is 01:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com