Hi!

I desperately need a hand here. I would like an average of money per time it is dispensed. As you can see below column A is sometimes dispersed in full and sometimes split up. I would like to use a formula to determine the average amount per dispersion.

Column A has amounts or "-"s. Column B has a date for each amount in A. Columns C and D then columns E and F do the same. Each column has a heading and filter. I've been using subtotal formulas to take the filtering into account.
I appreciate all help! Thank you!

money date money date money date
12 11/4/99 - - - -
10 12/3/10 - - - -
8 - 3 3/4/09 5 6/3/10
3 - 3 5/7/99 - -