RANGE FORMULA (1st cell)
O5 =SUM(O2:O4)
O9 =SUM(O7:O8)
O11 =SUM(O2:O9)/2
[Table-It] version 06 by Erik Van Geit
Range("O" & Rows.Count).End(xlUp).Offset(1) = "=sum(" & Columns("O:O").SpecialCells(xlCellTypeFormulas, 1).Address & ")"
thanks, guys, for jumping in while I was busyIts crystal clear now!!
...loving this teamwork