Drag and fill

Copper Contributor

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
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!