Excel help with meter readings

  Graham. 17:46 25 Sep 2009
Locked

I need to check my fuel consumption on a daily basis for a while.

Column A is the date, column B is Electricity Day, column C will be Total Used, column D is Electricity Night, column E will be Total Used, F is Gas, G is Total Used.

I would like the Totals to appear automatically when I enter a new reading. The Totals are 'used per day', not a running total.

  VoG II 18:02 25 Sep 2009

I'm confused!

Is there one row per day or multiple rows (if so why?).

  Graham. 19:24 25 Sep 2009
  Graham. 19:30 25 Sep 2009

Even better click here

  VoG II 20:11 25 Sep 2009

Then I don't understand the need for the Totals columns.

  Graham. 20:17 25 Sep 2009

When I enter tomorrows readings, I need to know the usage for that 24 hour period in columns C, E and G.

  VoG II 21:06 25 Sep 2009

Sorry but you are not being clear. Please post an example with a few rows filled showing what you expect to see in the Totals columns.

  Graham. 21:39 25 Sep 2009

click here

I've not labeled the daily usage columns (Totals). I have entered the calculations manually, I would like Excel to do it.

  Graham. 23:03 25 Sep 2009
  VoG II 07:50 26 Sep 2009

In C3 enter

=IF(B3="","",B3-B2)

and drag down as far as needed. Similarly with the other totals columns.

  Graham. 09:40 26 Sep 2009

Thanks, that works fine.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?