Formula to count to a certain number

[trev84]

I'm helping a local business create a tracker that will track energy consumption. Basically just meter readings. I've got the tracker down for the most part however the meter readings start over at 100,000 then starts back over at zero. Which leaves me with a huge negative balance. Is there a formula that will calculate two cells up to 100000, then count the difference from example 95,000 to 5,000 (answer would be 10,000). There's 150 meters, otherwise I'd manually change the values.

[#2 · Accepted solution]

@trev84 That could be something like this.

[#3]

@trev84 

Perhaps you may submit small sample file?

[#4]

@Sergei Baklan 

[#5]

Basically I'm just subtracting the current month's reading, from last month's reading to get the total usage. Easy, until I get to 100,000

[#6]

Thank you! That works!