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
> > >
> > >
> > >
>
>
>