Thread: wild cards in formulas and functions

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 work@discussions.microsoft.com> wrote in message
news:DD4870E7-C908-4879-A0A3-471F890CEFDE@microsoft.com...
> 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 work@discussions.microsoft.com> wrote in message
news:DD4870E7-C908-4879-A0A3-471F890CEFDE@microsoft.com...
> 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 work@discussions.microsoft.com> wrote in message
> news:DD4870E7-C908-4879-A0A3-471F890CEFDE@microsoft.com...
> > 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" <Carlaatwork@discussions.microsoft.com> wrote in message
news:B7F8812D-5896-4666-8A01-9AAD1FB33318@microsoft.com...
> 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 work@discussions.microsoft.com> wrote in
message
> > news:DD4870E7-C908-4879-A0A3-471F890CEFDE@microsoft.com...
> > > 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" <Carlaatwork@discussions.microsoft.com> wrote in message
> news:B7F8812D-5896-4666-8A01-9AAD1FB33318@microsoft.com...
> > 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 work@discussions.microsoft.com> wrote in
> message
> > > news:DD4870E7-C908-4879-A0A3-471F890CEFDE@microsoft.com...
> > > > 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 work@discussions.microsoft.com> wrote in message
news:DD4870E7-C908-4879-A0A3-471F890CEFDE@microsoft.com...
> 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 work@discussions.microsoft.com> wrote in message
news:DD4870E7-C908-4879-A0A3-471F890CEFDE@microsoft.com...
> 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 work@discussions.microsoft.com> wrote in message
> news:DD4870E7-C908-4879-A0A3-471F890CEFDE@microsoft.com...
> > 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
>
>
>