automatically numbering rows

[Tonso]

I have an XL2003 spreadsheet i use to enter data. It is constructed so
that column A has a formula...row()-10, which automatically number the
rows, which start at row 11. Col. B has is used to enter a
descriptions, and in cols. C - Q i enter numbers. Cols R - V have
formulas that summarize the data entered in C-Q. C-Q gives me 15 cols
to enter data. Sometimes i need additional cols. I cannot add columns
because the landscape printout would have to be inconveniently small.
I have macros that allow me to insert or delete rows with the formulas
in cols R-V. Of course this does not make my numbering wrong. What I
need is to be able to occasionally insert a row that would have no
formulas, to use to add additional numbers in excess of 15. The
problem is that these added 'data only' rows will mess up my numbering
formula. Is there a way to add a row, that I would not want numbered,
without making the numbered rows below it off by 1?

Thanks,

Tonso

 

[Tonso]

I have an XL2003 spreadsheet i use to enter data. It is constructed so
that column A has a formula...row()-10, which automatically number the
rows, which start at row 11. Col. B has is used to enter a
descriptions, and in cols. C - Q i enter numbers. Cols R - V have
formulas that summarize the data entered in C-Q. C-Q gives me 15 cols
to enter data. Sometimes i need additional cols. I cannot add columns
because the landscape printout would have to be inconveniently small.
I have macros that allow me to insert or delete rows with the formulas
in cols R-V. Of course this does not make my numbering wrong. What I
need is to be able to occasionally insert a row that would have no
formulas, to use to add additional numbers in excess of 15. The
problem is that these added 'data only' rows will mess up my numbering
formula. Is there a way to add a row, that I would not want numbered,
without making the numbered rows below it off by 1?

Thanks,

Tonso

I think i have a solution to my problem. =row()-10-countblank(A
$11:A15) where A15 is on the current row.
I am currently testing this formulas to determine if it works in all
situations.

Thanks to everyone who provides help on this usergroup!!

Tonso

 

[Claus Busch]

Hi Tonso,

if column B in inserted rows is empty, try in A11:
=IF(B11="","",COUNTA($B$11:B11))


Regards
Claus Busch