I am entering daily meter readings, I need to calculate daily use, total use
for the month, and average use per day for the month.
I am entering daily meter readings, I need to calculate daily use, total use
for the month, and average use per day for the month.
in the column next to the input (c1:c1000)? enter =c2-c1
and copy down this is the daily use
if C10 were the beginning of one month and C40 the beginning of the next month
=c40-c10 would be the use for that month
(Depending on how your month is defined It might be = C39-C9)
=(C40-C10)/30 would be the daily useage for month with 30 days
"Centurion" wrote:
> I am entering daily meter readings, I need to calculate daily use, total use
> for the month, and average use per day for the month.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks