Daily Average

[MCorn]

Hi
I have a spreadsheet that I would like to figure the daily average. The current worksheet is set up like this
Date: CashOut: CashIn: Balance
2/4/04 100.00 100.0
2/5/04 50.00 50.0

In the Balance column, I have a running balance that is figured automatically each time I add a figure in the CashOut or
CashIn columns. My question is this: Is there a formula that I can use to calculate a daily average? In the example above, I would like to divide the last figure in the balance column (50.00) by the number of dates posted in the Date column. (E.G. 50.00/2 or if there were four dates in the date column 50.00/4
Thanks for any help! MCorn

 

[Mark Graesser]

Hi MCorn
Could you have more than one entry for a single date? Probably the best way to do this is to divide by the difference of the date on that line and the starting date. Say you are on row 10 and the starting date is on Row 2, then use

=D10/(A10-$A$2

A2 is an absolute reference so it won't change when you copy the formula

If you only want the average for working day, then change the denominator to a WORKDAY function

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- MCorn wrote: ----

Hi
I have a spreadsheet that I would like to figure the daily average. The current worksheet is set up like this
Date: CashOut: CashIn: Balance
2/4/04 100.00 100.0
2/5/04 50.00 50.0

In the Balance column, I have a running balance that is figured automatically each time I add a figure in the CashOut or
CashIn columns. My question is this: Is there a formula that I can use to calculate a daily average? In the example above, I would like to divide the last figure in the balance column (50.00) by the number of dates posted in the Date column. (E.G. 50.00/2 or if there were four dates in the date column 50.00/4
Thanks for any help! MCorn

 

[Mark Graesser]

Oops! I should have said NETWORKDAYS

----- Mark Graesser wrote: ----

Hi MCorn
Could you have more than one entry for a single date? Probably the best way to do this is to divide by the difference of the date on that line and the starting date. Say you are on row 10 and the starting date is on Row 2, then use

=D10/(A10-$A$2

A2 is an absolute reference so it won't change when you copy the formula

If you only want the average for working day, then change the denominator to a WORKDAY function

Good Luck
Mark Graesse
(e-mail address removed)
Boston M


----- MCorn wrote: ----

Hi
I have a spreadsheet that I would like to figure the daily average. The current worksheet is set up like this
Date: CashOut: CashIn: Balance
2/4/04 100.00 100.0
2/5/04 50.00 50.0

In the Balance column, I have a running balance that is figured automatically each time I add a figure in the CashOut or
CashIn columns. My question is this: Is there a formula that I can use to calculate a daily average? In the example above, I would like to divide the last figure in the balance column (50.00) by the number of dates posted in the Date column. (E.G. 50.00/2 or if there were four dates in the date column 50.00/4
Thanks for any help! MCorn