You could have

=SUM(a1:A100) - A35

assuming your subtotal row is 35.

Hope this helps.

Pete

Andrew Dyson wrote:

I would like to SUM a long column of numbers. However, I would like to
insert a subtotal half way down the column. Of course, I do not want that
subtotal to be included in the SUM total. When I insert that subtotal row,
can I tell Excel somehow to ignore/exclude that row from the SUM
calculation.

Thank you