Thread: Two Questions
View Single Post
  #3   Report Post  
bigwheel
 
Posts: n/a
Default

Answer 1

One way I've thought of is to enter the formula =ROW() into convenient cells
on rows 5 and 8, say A5 and A8.
Then for your comment enter the formula
=TEXT("Total of rows " & A5 & " to " & A8,)

Answer 2

If you have a formula =SUM(C5:C11) and you insert a row within that range
i.e. 6 - 11, then the formula will change. If you insert a new row 5 or 12
however, the formula will not change.