[users] "Criterion" in Excel

[Stephan Michelson]

I want to condition a calculation on a value in a column (that is, the same 
cell in each row).  Example: balance of only cleared checks and deposits in a 
bank account.  I place an x in the column "clear," and want to be able to tell 
Calc that a certain row contains conditions.  If, in that row, there is an x 
under "clear," then only those rows with such an x will be counted.  This is 
done through the "criterion" option under "sum" in Excel.
        -- SM