SOLVED

Formula to count to a certain number

New Contributor
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.
5 Replies
best response confirmed by trev84 (New Contributor)
Solution

@trev84 That could be something like this.

Screenshot 2021-12-14 at 20.41.24.png

@trev84 

Perhaps you may submit small sample file?

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
Thank you! That works!