Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Centurion
 
Posts: n/a
Default Calculate difference from assending data

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   Report Post  
bj
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
calculate difference in time to hours Chris Excel Worksheet Functions 5 January 18th 05 06:07 PM
How do I calculate difference in days & hours between two dates e. probi2 Excel Worksheet Functions 1 January 12th 05 03:59 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM
How do you calculate the difference between two values within a p. emlouise Excel Discussion (Misc queries) 2 December 10th 04 03:13 AM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"