Row counter in formula
I add and subtract rows of data each week. One of the simple formulas
includes how many rows there are. How do I include the row number in a
formula? =SUM(F24/22) 22 refers to the first column which is a row counter
which contains 1,2,3,4,5,6..etc as I don't know how to enter a row counter in
the formula that is automatically updated as I add or delete rows.
|