>only because the sample data has no negatvie values ;-)
>

Ah, good point.

Tamar
>>
>>Rick has given you the answer to your question, but I want to point out that you don't need the IIF() for the SUM() calculations. The result will be the same whether you add the zeroes in or not.
>>
>>Tamar