If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I set up the formula to update automatically?
I have a sheet with 12 columns, 1 for each month. I am updating it monthly
and I want it to take the average of the months I've used as I update it. The problem is that the numbers I'm entering are vehicle mileage. Example: Average Usage November December January 91667 91778 91822 In order to get the average usage I would subrtact December from November to see that 111 miles were used that month, then do the same for January and get the average of the months thus far. Here is the one I'm using: =IF(COUNTA(I13:V13)0,((J13-I13)+(K13-J13))/(COUNTA(J13:V13)),"") J13 - December I13 - November K13 - January V13 is the final month. I'd like to set it up so that each time I put in the mileage for a new month the "Average Usage" will be updated. I've got a formula right now, but I have to update the formula each month in order for it to work. If you have any questions feel free to ask. Thanks in advance. |
#2
|
|||
|
|||
How about
(Max(range)-MIN(range))/count(range) "pugsly8422" wrote: I have a sheet with 12 columns, 1 for each month. I am updating it monthly and I want it to take the average of the months I've used as I update it. The problem is that the numbers I'm entering are vehicle mileage. Example: Average Usage November December January 91667 91778 91822 In order to get the average usage I would subrtact December from November to see that 111 miles were used that month, then do the same for January and get the average of the months thus far. Here is the one I'm using: =IF(COUNTA(I13:V13)0,((J13-I13)+(K13-J13))/(COUNTA(J13:V13)),"") J13 - December I13 - November K13 - January V13 is the final month. I'd like to set it up so that each time I put in the mileage for a new month the "Average Usage" will be updated. I've got a formula right now, but I have to update the formula each month in order for it to work. If you have any questions feel free to ask. Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can delegate automatically receive mgr's meeting update? | bkw | General Discussion | 0 | February 7th, 2005 07:49 PM |
automatically update other fields based on input in another | Custom Minis | General Discussion | 3 | January 24th, 2005 06:53 PM |
how do i update custom fields automatically on opening | mackem | General Discussion | 4 | September 21st, 2004 11:26 AM |
automatically update field codes | Simone | Mailmerge | 1 | June 3rd, 2004 06:55 AM |