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?

Attached Files

Book1.xlsx (8.6 KB, 9 views)

Hi, yes, that all makes sense, and I follow.

I think where the confusion is, is that I was interpreting the statement of returning True or False literally, ie, useing the value True as THE criteria. Not the answer to the criteria.

I'm in synch.

I appreciate your input.