LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Carla at work
 
Posts: n/a
Default wild cards in formulas and functions

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What Formulas or Functions to use??!!! aeiou Excel Discussion (Misc queries) 2 July 27th 05 04:27 AM
Database Functions - question using formulas as criteria msnews.microsoft.com Excel Worksheet Functions 0 June 9th 05 12:10 PM
Functions and formulas abfabrob Excel Discussion (Misc queries) 4 April 13th 05 08:04 PM
How do I get to master Excel functions and formulas? Basabjit Chowdhury Excel Worksheet Functions 3 December 29th 04 08:15 PM
OLAP write back via formulas (functions), not read only pivot tab BISability Excel Worksheet Functions 0 November 18th 04 04:15 AM


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"