Forum Discussion

Copper Contributor

Apr 18, 2021

AutoSum

Hi! When I highlight a group of cells in a column and hit 'Autosum' I get the total of numbers in the whole column not just the highlighted cells. I can manually enter for instance '=Sum(F4:F12)' a...

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Apr 19, 2021

HillaryC Unless I'm mistaken, that's exactly how AutoSum is supposed to work. Column wise or row wise.

https://support.microsoft.com/en-us/office/use-autosum-to-sum-numbers-543941e7-e783-44ef-8317-7d1bb85fe706#ID0EAACAAA=Windows

HillaryC

Copper Contributor

Apr 19, 2021

My understanding it that when you have selected a section of numbers within a column and then use the autosum button it should only total the selected numbers not the whole column.