I was using the 0;-0;"" format to get rid of the 0's in my table, so that I could see at a glance where my -1's where... However when it counts (totals) down at the bottom, even though the 0's arn't showing up, they are still being counted. Is there a way I can just query the table, then have the 0's gone and the absolute value of the 1 there so I can just use the sum function and don't have to worry about it?