Capturing Maximum and Minimum values

[tx12345]

Hi

Lets sy I have a cell that sums a range of cells.

b11 is =sum(b1:b10)

Let's say I have a condition where the sum will periodically change,
because some cells above will either have a value, or not have a value
as time goes by, or the values change, which will on any given revision
of the data in b1:b10 change the bottom line sum in b11.

What I want to do is be able to capture in another field what the
maximum sum, and minimum sums were.

For example:

on 12/3 the sum in b11 was 1000
on 12/4 the sum in b11 was 5000
on 12/6 the sum in b11 is 2500


So as of 12/6, the MAX sum was 5000 and the MIN was 1000. Is there a
simple way to keep a record of what had been transpiring in b11 so I
can know what the MAX and MIN was?

Thx

 

[Greg Wilson]

Try selecting the Iteration check box through Tools > Options > Calculation
tab. This will suppress the circular reference problem. Example:

A6 contains the formula:
=Sum(A1:A5)
B6 contains the formula:
=Max(A6, B6)
Then B6 will record the max value it sees in A6 which is the max of values
entered into A1:A5.

Regards,
Greg