average of decreased amount

[MrJim005]

In column A, rows 1 through 31. Each row represents a day's fund. We need a
way to return the value, in a separate cell somewhere, of an average use. By
that almost everyday the amount will decrease and we want to know what that
average amount of decrease is for the day to day use of all 31 days. But on
some days the fund is replenished and the amount grows and we don't want
that included in the average. Only an average of decreased amount is needed.



Thank You if this can be done.

 

[Max]

Perhaps one way ..

Assume data in A1:A31

In B2: =A1-A2
B2 copied down to B31

Then just place in say, C2, and array-enter the formula,
ie press CTRL+SHIFT+ENTER (instead of just pressing ENTER):
=AVERAGE(IF(B2:B31>0,B2:B31))

C2 should return the " average of decreased amounts only (per day)"

 

[Biff]

Try this:

Formula entered as an array using the key combination of CTRL,SHIFT,ENTER
(not just ENTER):

=AVERAGE(IF(A2:A31-A1:A30<0,A2:A31-A1:A30))

Biff