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