"Pete_UK" wrote in message
oups.com...
Assume you use row 1 for headings. You can record a date in column A
and the meter reading in column C. That allows you to have a "Days" in
column B, with a formula like:

=IF(A3="",0,A3-A2)

and formatted as a number with 0 dp. In column D you can obtain the
difference between the current reading and the one before it with a
formula like:

=IF(C3="",0,C3-C2)

This should be entered in D3, as row 2 will be for the opening reading.
To overcome the problem of the meter wrapping round, you can use this
formula in E3 for the actual kWh:

=IF(D3<0,D3+100000,D3)

You can copy the formulae in B3, D3 and E3 down for as many months as
you expect to do this for.

Once you have set this up as you would like (you would probably use
more header rows so that you can record details of the meter, and
location etc), you can then copy the sheet so that you have one sheet
for each meter. If you wish, you can summarise the information from
each sheet onto a master sheet.

Hope this helps.


Thank you

I think this looks like what I'm aiming for.