Drag and fill

%3CLINGO-SUB%20id%3D%22lingo-sub-2376989%22%20slang%3D%22en-US%22%3EDrag%20and%20fill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2376989%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20try%20to%20drag%20and%20fill%20a%20SUM%20formula%2C%20i%20only%20get%20the%20cell%20value%20replicated%2C%20not%20the%20formulae.%20What%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2376989%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2377129%22%20slang%3D%22en-US%22%3ERe%3A%20Drag%20and%20fill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2377129%22%20slang%3D%22en-US%22%3EPlease%20show%20us%20a%20picture%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2377502%22%20slang%3D%22en-US%22%3ERe%3A%20Drag%20and%20fill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2377502%22%20slang%3D%22en-US%22%3EHans%20Vogelaar%20has%20answered%20my%20question%20in%20response%20to%20a%20different%20post.%3CBR%20%2F%3E%22Make%20sure%20that%20Calculation%20Options%20on%20the%20Formulas%20tab%20of%20the%20ribbon%20is%20set%20to%20Automatic%22%3CBR%20%2F%3EThanks!%3C%2FLINGO-BODY%3E
New 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!