Skip to main content
4 events
when toggle format what by license comment
May 3, 2018 at 10:05 comment added Jerry You can simply lock part of the cell using sum instead of using indirect, row and column. So using the formula =sum(B$2:B2)/(row()-1) in E2 will give the same result.
Mar 20, 2017 at 10:17 history edited CommunityBot
replaced http://superuser.com/ with https://superuser.com/
Jun 5, 2016 at 4:32 vote accept Kim Stacks
Jun 4, 2016 at 2:03 history answered Sun CC BY-SA 3.0