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?
Yea_So
May 21, 2021Bronze Contributor
Please show us a picture
- nikitaljaardMay 22, 2021Copper 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!