Hi All, Im new here. Wonder if anyone can help me with this. I wanted to have a formula that divides by no of rows at the top.
Example:
Row 1
Row 2
Row 3
Row 4 (I have a Sum formula that divides by number of rows at the top, in this case its 3)
I could have doing the sum formula divide by 3, and then change the 3 to 4 and 5,6,7,8 etc whenever i insert a new row. However, its extremely tedious to do that. Reckon perhaps a countif formula might work, but have no idea how to do it. Apppreciate if any expert here could offer some help.
Example:
Row 1
Row 2
Row 3
Row 4 (I have a Sum formula that divides by number of rows at the top, in this case its 3)
I could have doing the sum formula divide by 3, and then change the 3 to 4 and 5,6,7,8 etc whenever i insert a new row. However, its extremely tedious to do that. Reckon perhaps a countif formula might work, but have no idea how to do it. Apppreciate if any expert here could offer some help.