Forum Discussion
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?
Please show us a picture
Hans 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!
"Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic"
Thanks!