Wild Card / Character

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kurt - 30 Jan 2008 06:19 GMT

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

Reply to this Message

Pete_UK - 30 Jan 2008 09:24 GMT

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
>
[quoted text clipped - 13 lines]
> Anyone have an Idea
> Kurt

Reply to this Message

kurt - 30 Jan 2008 09:54 GMT

> 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

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

Reply to this Message

Pete_UK - 30 Jan 2008 10:13 GMT

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

> if I want to sumarize in Column C Based on the second character in
> Column A
[quoted text clipped - 7 lines]
>
> Kurt

Reply to this Message

Roger Govier - 30 Jan 2008 13:08 GMT

Hi Kurt

Could you not use
=SUMIF(A:A,"=2?A*",C:C)

Signature

Regards
Roger Govier

>> What are you trying to do? Summarize column C if the first character
>> of column A is any character? Doesn't make sense.
[quoted text clipped - 14 lines]
>
> Kurt

Reply to this Message