I don't have '08 (so I don't know what formulas are and are not available to you) but in '09:
If the tables have no empty rows, a count of the number of rows should suffice.
=ROWS(Table 1::A)-1 assuming a single header row and no footer row
The count will adjust corrrectly when you add or delete rows.
If the tables might have blank rows,
=COUNTA(Table 1::A) - 1
In this case, pick a column that will definitely be filled in whenever you add a song.
To enter a formula select the cell where you want the formula, then enter the formula (by typing or pasting). e.g. Jerry posted to:
In Column A, I would write: =IF(LEN(B)>0, ROW()-1 & "."
In the first non-header cell of column A (cell A1) enter the text "=IF(LEN(B)>0, ROW()-1 & ".", "")"
It should look like:
shorthand for this is:
A2=IF(LEN(B)>0, ROW()-1 & ".", "")
then to fill in the rest of the column select cell A2, then grab (click and hold) the little circle at the the bottom-right of the selected cell, then drag straight down as needed, then release the mouse button. You can also select cell A2, copy, then click cell A3, and scroll to the end of the column, then hold the shitft key, and click the last cell of the column, then paste.
it can be very helpful to copy the formulas directly from the posts, so click and hold starting at the "=" and then drag to the end end of the formula like:
then copy, the select the target cell in Number, then paste