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?
|