View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default consecutive numbers

"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.