Forum Discussion
nikitaljaard
May 21, 2021Copper Contributor
Drag and fill
When I try to drag and fill a SUM formula, i only get the cell value replicated, not the formulae. What am I doing wrong?
2 Replies
- Yea_SoBronze ContributorPlease show us a picture
- nikitaljaardCopper ContributorHans Vogelaar has answered my question in response to a different post.
"Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic"
Thanks!