readings from water meter add a monthly use column

[BSCIC]

I enter water meter readings at different times and dates. The info below is a sample of the data I have in my excel sheet. I need a formula that will take my data and give me the exact total acre feet usage per month.

Date/Time - 2016 Flow From Totalizer (gpm) - Totalizer Reading - 2016 Running Total Acre-ft

4/30/16 2:13 PM - 352 - 214139000 - 189.0956296
5/13/16 9:51 AM 345 220501000 208.6198907
5/22/16 2:30 PM 354 225187000 223.0006966
5/25/16 3:05 PM 351 226715000 227.6899565
6/16/16 7:40 AM 354 237768000 261.6103679
6/28/16 11:21 AM 354 243958000 280.6067804
7/9/16 1:48 PM 353 249596000 297.9091671
7/9/16 5:00 PM 0 249596000 297.9091671
7/21/16 2:21 PM 354 255661000 316.5219686
7/30/16 2:13 PM 350 260192000 330.427097
8/12/16 2:38 PM 348 266722000 350.4669312

[Logit]

If you were to compute using paper and pencil .... what does the formula look like ?

What are you multiplying, dividing, subtracting, etc. ?

What from what ... or ... what by what ?

I did a search on the internet to try and understand acre feet and it all looks like Greek to me.

[Glenn Kennedy]

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[BSCIC]

Attached a copy of document. Thank you.

[Logit]

.
Are the figures in Col D accurate for 2016 ?

[Glenn Kennedy]

Try this... BtW, since your profile shows Excel 21010, is there are reason that you are contiuing to use th eoutdated .xls extensions (2003 and before). happy to explain. can't do so now, however.

[BSCIC]

Thank you, I will review and get back with any questions, I appreciate the help. The sheet was carried over from previous years, I will update and save with current version.