Hard to explain question

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?

It is possible, but it will require VBA event code associated with the worksheet_change event. This kind of question gets asked quite frequently, so if you use the forums search engine, you should be able to find some sample code to use as a starting point.

Originally Posted by oldchippy

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")

Awesome, thank you very much!