Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
How do you calculate the difference between two values within a p. | Excel Discussion (Misc queries) |