wild cards in formulas and functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
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)
 
If wslacct consists of text-formatted account numbers, each entered as
'11005507720, the formula you have will 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
 
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.
 
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
 
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)
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top