I have a column of dates in Sheet1 Column A. In Sheet 2 Columns A thru J, I
have a list of random numbers. Is there a way to average each number that
comes up. For example: Sheet1 has a date of 8/1/09 with a "1" on
Sheet2.(=COUNTIF(Sheet1!B:F,"1") This gets me the number of "1"s Then the "1"
does not show up again untill 8/5/09, then again on 8/6/09. A total of 3
"1"'s. I need a formula that shows the average time from the first "1" to the
last "1". Thanks in advance!!!