![](https://image.jimcdn.com/app/cms/image/transf/dimension=475x1024:format=png/path/sed039f50cee9e95f/image/ic0c012322c626420/version/1536382658/image.png)
Sometimes you want to total (or Sum) a column when some cells have existing subtotal values. How do you stop Excel from adding the subtotal values into the calculation (double-calculation)?
Logic dictates to use the SUM function; use the SUBTOTAL function instead.
The subtotal function ignores any values already 'sub-totaled', in other words it will not double-calculate the column.
A video tutorial on this topic is also available on the 'Free Resources' page.
Write a comment