Hmm... my test resulted in no change regardless of what data was entered in
cell R1. Your response prompted further testing. You are correct only if
the formula is also entered in row 1.

So, to amend my original response, the R:R+ does do something after all. It
will take the value found in Column R of the same row that the formula is
entered into. Then add that value to the Maximum number.

So, if the formula is entered into cell B31, then the result would be the
value of cell R31 + the maximum value found in (B6:B30).

HTH,
Elkar


"Biff" wrote:

As written, the R:R+ does nothing.

Actually, it does the equivalent of:

R1+MAX(B6:B30)

Of course, if R1 was empty then it would be:

0+MAX(B6:B30)

If the formula:

=R:R+MAX(B6:B30)

was entered as an array into a range of cells then it would be the
equivalent of:

R1+MAX(B6:B30)
R2+MAX(B6:B30)
R3+MAX(B6:B30)
R4+MAX(B6:B30)
etc
etc

Biff

"Elkar" wrote in message
...
As written, the R:R+ does nothing. The R:R refers to the entire column R
and
the plus is just a plus (addition symbol). It has the ultimate effect of
adding 0 to your Maximum number.

Where you'd use R:R would be inside a function that calls for a range.
Such
as SUM(R:R) would give you the sum of all numbers in column R.

HTH,
Elkar


"r" wrote:

A person typed some numbers in column A (line 2 to line 10)
then in line 12 she wanted to show the maximum number in the column

to show that value, the only formula I know is .. =MAX(B6:B30)

However, she used the following formula:
=R:R+MAX(B6:B30)

can any one tell me what the "R:R" stands for? and why there is a plus
mark?

Thank you