Hey there, I'm working on a speed sheet to help me keep record of my
electricity usage. I have 4 meters, I would like to telly up my daily usage
across all 4 meters.
I require a formula in MS Excel to help me achieve this.
Example:
Meter Reading Record
Serial Number 59802 59803 59804 59805
Type General General Range Hot Water
Day Date Meter 1 Meter 2 Meter 3 Meter 4 Daily Usage
Thursday 8/19/2010 8290 3714 7148 9738
Friday 8/20/2010
So when adding Friday's data under Daily usage only the difference in the
total sum appears under daily usage for that day.
Hope it makes sense. Cheers