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