wild cards in formulas and functions

[Carla at work]

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

 

[DaveB]

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?

 

[Bob Phillips]

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)

 

[Bob Phillips]

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)

 

[Aladin Akyurek]

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

 

[Carla at work]

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

 

[Carla at work]

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.

 

[Carla at work]

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

 

[Bob Phillips]

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]

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.