Morning All,
I am wondering if there is a way to account for roll over numbers.
I use monthly meter readings: I subtract the previous reading from the current reading to get the total usage during the billing period. But the numbers roll over once it reaches 100,000 or 1,000,000.
Here is my example (I also attached an image of the workbook):
C4 is the current meter usage
D4 is the most recent meter reading
E4 is the meter reading prior to the most recent meter reading
C4=D4-E4
D4=INDEX(G4:OB4,1,COUNTA(G4:OB4))
E4=INDEX(G4:OB4,1,COUNTA(G4:OB4)-1)
How do I account for when the meter rolls over in my calculations? I'm basically trying to have everything auto-populate other than entering the new meter reading data each new month. This data will in turn populate the individual client invoices.
Any ideas would be super as I feel like I've gone down a bit of a rabbit hole on this one, lol!
Thanks,
Jenn
I am wondering if there is a way to account for roll over numbers.
I use monthly meter readings: I subtract the previous reading from the current reading to get the total usage during the billing period. But the numbers roll over once it reaches 100,000 or 1,000,000.
Here is my example (I also attached an image of the workbook):
C4 is the current meter usage
D4 is the most recent meter reading
E4 is the meter reading prior to the most recent meter reading
C4=D4-E4
D4=INDEX(G4:OB4,1,COUNTA(G4:OB4))
E4=INDEX(G4:OB4,1,COUNTA(G4:OB4)-1)
How do I account for when the meter rolls over in my calculations? I'm basically trying to have everything auto-populate other than entering the new meter reading data each new month. This data will in turn populate the individual client invoices.
Any ideas would be super as I feel like I've gone down a bit of a rabbit hole on this one, lol!
Thanks,
Jenn