Wild Card / Character

  • Thread starter Thread starter kurt
  • Start date Start date
K

kurt

Hi


Using the formula in excel = sumproduct(--
(left(A1:A200;1)="2");c1:c200)
it means that take the first digit in column a if this i equal to 2
then sumarize C column
this vorks fine.
But if I change the "2" to a wild Character such as "*" or "?" it does
not function.
nor if I Use "~*" or "~?"

The tilde I use is [ALT}126

The A colunm does include text only
I use XP 2003
Anyone have an Idea
Kurt
 
What are you trying to do? Summarize column C if the first character
of column A is any character? Doesn't make sense.

Pete
 
What are you trying to do? Summarize column C if the first character
of column A is any character? Doesn't make sense.

Pete

Hi Pete
Click to expand...

if I want to sumarize in Column C Based on the second character in
Column A
If I want the expression to be something as "2?A" then it should
summarize column C based on the first character is 2, the second
character is not interesting and the third character is A thatas is
the meaning
where I expect ?to be a wild Character.

regards

Kurt
 
Okay, try it this way:

= sumproduct(--(left(A1:A200;1)="2");--
(mid(A1:A200;3;1)="A");c1:c200)

checks for first character being "2" and third character being "A".

Hope this helps.

Pete
 
Back
Top