|
| 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
May 18th 12, 03:49 PM
|
|||
|
|||
Max/Min per item from a changing list
I am pulling in a DIR text file daily. This gives me
a=date, b=time, c=filesize, d=filename each day there are a different number of entries, 10-40, some days none. I want to calculate the thru-put of the file creations. On the 20th, the first file was made at 8am and the last was 5pm, sum of the file sizes is 1800. So 9 hours made 1800 = 200 per hour. sumif(a:a,a2,b:b) gets me the filesize based on date. How do I get the max/min time for a date to find my time difference complete the formula? The goal is when I add more data tomorrow, I just copy the formula down or have it already there. 
|
| Ads |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| List and subtotal selected items, then print separate item list | TitanG | Excel Worksheet Functions | 0 | September 8th 08 09:07 PM |
| I need to pair each item on one list to each item on another list | Peter R. | Excel Worksheet Functions | 1 | August 24th 07 03:04 AM |
| Dropdown List - list item endings not visible if column too narrow | AK9955 | Excel Discussion (Misc queries) | 2 | April 27th 07 09:02 AM |
| changing value of a cell by selecting an item from a drop down list | Bobby Mir | Excel Worksheet Functions | 6 | June 8th 05 08:33 PM |
| Selecting an Item from a List and getting a different item to pop. | Matt | Excel Worksheet Functions | 1 | December 7th 04 02:37 PM |
Linear Mode
