consecutive numbers
If I enter this formula in B2:
=ROWS($1:1)*$A$4
Then insert a new row 1, the formula correctly changes the references to:
=ROWS($2:2)*$A$5
Which is the equivalent of:
=1*$A$5
How does inserting a new row above the formula cell mess up the ROWS
function?
--
Biff
Microsoft Excel MVP
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Phippsy,
As you have found, using the ROWS function is not better than using the
ROW function, since inserting a new row 1 will mess up the ROWS formula,
but not the one ROW()-ROW($a$5) etc that I posted.
HTH,
Bernie
MS Excel MVP
"Phippsy" wrote in message
...
The last one I understand having looked what the ROWS function does
however
why is this better than using the ROW() function?
Thanks
"Harlan Grove" wrote:
"T. Valko" wrote...
Another one:
=ROWS($1:1)*$A$4
....
Better to start with a single cell, e.g., if the formula were entered
in cell X99,
X99:
=ROWS(X$99:X99)*$A$4
since any entries/changes anywhere in row 1 would cause your formula
to recalc.
|