wild cards in formulas and functions
 

I'm using Excel 2000 and want to use wild cards.. For instance, I'm using
the sumif function and want to put something like

=SUMIF(wslacct,"1100550??20",wsldr)-SUMIF(wslacct,"1100550??20",wslcr)

and excel just doesn't seem to like this. Is there some way I can get excel
to use the wild cards? The help function only mentions use of wild cards in
searches.

Thanks,
Carla

That should work. What do you mean when you say Excel doesn't seem to like
this? Did you get an error message? A zero value? An incorrect value?

--
Regards,

Dave


"Carla at work" wrote:

I'm using Excel 2000 and want to use wild cards.. For instance, I'm using
the sumif function and want to put something like

=SUMIF(wslacct,"1100550??20",wsldr)-SUMIF(wslacct,"1100550??20",wslcr)

and excel just doesn't seem to like this. Is there some way I can get excel
to use the wild cards? The help function only mentions use of wild cards in
searches.

Thanks,
Carla

The syntax you have given works perfectly for me.

You do know that is one character, not any number of characters, that is
*?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Carla at work" <Carla at wrote in message
...
I'm using Excel 2000 and want to use wild cards.. For instance, I'm using
the sumif function and want to put something like

=SUMIF(wslacct,"1100550??20",wsldr)-SUMIF(wslacct,"1100550??20",wslcr)

and excel just doesn't seem to like this. Is there some way I can get
excel
to use the wild cards? The help function only mentions use of wild cards
in
searches.

Thanks,
Carla

That last sentence should be

You do know that ? is one character, not any number of characters?
Any number is *.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Carla at work" <Carla at wrote in message
...
I'm using Excel 2000 and want to use wild cards.. For instance, I'm using
the sumif function and want to put something like

=SUMIF(wslacct,"1100550??20",wsldr)-SUMIF(wslacct,"1100550??20",wslcr)

and excel just doesn't seem to like this. Is there some way I can get
excel
to use the wild cards? The help function only mentions use of wild cards
in
searches.

Thanks,
Carla

If wslacct consists of text-formatted account numbers, each entered as
'11005507720, the formula you have will work.

Carla at work wrote:
I'm using Excel 2000 and want to use wild cards.. For instance, I'm using
the sumif function and want to put something like

=SUMIF(wslacct,"1100550??20",wsldr)-SUMIF(wslacct,"1100550??20",wslcr)

and excel just doesn't seem to like this. Is there some way I can get excel
to use the wild cards? The help function only mentions use of wild cards in
searches.

Thanks,
Carla

Thanks for your reply. I thought so, too. I'm getting a return of zero, as
if it's looking for the question marks. When I substitute one of the actual
values, I'm getting back the amount I expect to see.

Carla

"DaveB" wrote:

That should work. What do you mean when you say Excel doesn't seem to like
this? Did you get an error message? A zero value? An incorrect value?

--
Regards,

Dave


"Carla at work" wrote:

I'm using Excel 2000 and want to use wild cards.. For instance, I'm using
the sumif function and want to put something like

=SUMIF(wslacct,"1100550??20",wsldr)-SUMIF(wslacct,"1100550??20",wslcr)

and excel just doesn't seem to like this. Is there some way I can get excel
to use the wild cards? The help function only mentions use of wild cards in
searches.

Thanks,
Carla

Thanks for replying. Yes, I was using the ? to replace 2 digits in the
middle of the account. It's returning zero. When I replace them with 2 of
the actual digits, it's retruning the correct value.

"Bob Phillips" wrote:

That last sentence should be

You do know that ? is one character, not any number of characters?
Any number is *.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Carla at work" <Carla at wrote in message
...
I'm using Excel 2000 and want to use wild cards.. For instance, I'm using
the sumif function and want to put something like

=SUMIF(wslacct,"1100550??20",wsldr)-SUMIF(wslacct,"1100550??20",wslcr)

and excel just doesn't seem to like this. Is there some way I can get
excel
to use the wild cards? The help function only mentions use of wild cards
in
searches.

Thanks,
Carla

Thanks for your reply. Yes, that's what the account numbers look like. I'm
getting a return of zero. When I replace the ? with the actual digits, I get
back the correct amount.

Carla

"Aladin Akyurek" wrote:

If wslacct consists of text-formatted account numbers, each entered as
'11005507720, the formula you have will work.

Carla at work wrote:
I'm using Excel 2000 and want to use wild cards.. For instance, I'm using
the sumif function and want to put something like

=SUMIF(wslacct,"1100550??20",wsldr)-SUMIF(wslacct,"1100550??20",wslcr)

and excel just doesn't seem to like this. Is there some way I can get excel
to use the wild cards? The help function only mentions use of wild cards in
searches.

Thanks,
Carla

Can you mail me your workbook, everyone agrees it should work, but it isn't!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Carla at work" wrote in message
...
Thanks for replying. Yes, I was using the ? to replace 2 digits in the
middle of the account. It's returning zero. When I replace them with 2
of
the actual digits, it's retruning the correct value.

"Bob Phillips" wrote:

That last sentence should be

You do know that ? is one character, not any number of characters?
Any number is *.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Carla at work" <Carla at wrote in
message
...
I'm using Excel 2000 and want to use wild cards.. For instance, I'm
using
the sumif function and want to put something like


=SUMIF(wslacct,"1100550??20",wsldr)-SUMIF(wslacct,"1100550??20",wslcr)

and excel just doesn't seem to like this. Is there some way I can get
excel
to use the wild cards? The help function only mentions use of wild
cards
in
searches.

Thanks,
Carla

Thanks, Bob. I've been playing with it a little while longer and I'm using
similar data from 2 different sources. The example I sent isn't working and
another piece is. So it's obvious now to me that it does work. I just must
have something formatted wrong in the piece that isn't working.

"Bob Phillips" wrote:

Can you mail me your workbook, everyone agrees it should work, but it isn't!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Carla at work" wrote in message
...
Thanks for replying. Yes, I was using the ? to replace 2 digits in the
middle of the account. It's returning zero. When I replace them with 2
of
the actual digits, it's retruning the correct value.

"Bob Phillips" wrote:

That last sentence should be

You do know that ? is one character, not any number of characters?
Any number is *.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Carla at work" <Carla at wrote in
message
...
I'm using Excel 2000 and want to use wild cards.. For instance, I'm
using
the sumif function and want to put something like


=SUMIF(wslacct,"1100550??20",wsldr)-SUMIF(wslacct,"1100550??20",wslcr)

and excel just doesn't seem to like this. Is there some way I can get
excel
to use the wild cards? The help function only mentions use of wild
cards
in
searches.

Thanks,
Carla