|
|
#9
11-20-2012, 10:44 AM
|
||||
|
||||
No, the criteria in your formula is applied to each row in the database. So you can use it to apply criteria across a row in the database which would be difficult or impossible to do by laying out the criteria how I mentioned earlier.
I've attached an example. In it I want to get a sum but only where the name begins with a capital "C". The criteria I'm using is: =EXACT(LEFT(B3,1),"C") So the LEFT() function gets the first letter and EXACT() returns TRUE or FALSE depending on if the first letter is a capital "C". Does that make sense? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Acos, Cos and Sin functions in DAX PowerPivot | eramzan | Excel | 0 | 03-01-2012 11:32 AM |
| Using IF and Vlookup functions | cpladson | Excel | 3 | 12-14-2011 11:57 PM |
 Assign functions to F1, etc.
|
ibclare | Office | 4 | 06-02-2011 03:22 PM |
|
** Using Functions
|
djreyrey | Excel Programming | 10 | 02-08-2011 04:18 PM |
| Automated Functions?? | nickypatterson | Outlook | 0 | 08-27-2009 01:50 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode