Quote Originally Posted by odditie
Ok, here's what I'm looking to do. I will be filling in values on a sheet and I was wondering if it's possible to set up a formula that subtracts 1 from a value each time a different cell is set to anything other then 0.

http://img244.imageshack.us/img244/6545/picture2rx9.png

Here's an image to help explain my question. If you look at cell B48 it shows the number 105. Each time I change one of the 0 from the row E to a positive whole number I'd like it to just take -1 to B48. Is that possible?
If you use this formula, it will count how many values in the ranges of column E are above zero, then you can take the total away from B48

=COUNTIF(E2:E10,">0")+COUNTIF(E13:E22,">0")+COUNTIF(E25:E31,">0")+COUNTIF(E34:E42,">0")