I understand your frustration with the AutoSum function in Excel. The reason why you are getting a SUBTOTAL function instead of a SUM function is because Excel is trying to be smart and assume that you want to perform a subtotal calculation on a range of data. However, you can easily change this behavior by following these steps:

1. Click on the cell where you want to insert the SUM function.
2. Click on the AutoSum button or press Alt+= on your keyboard.
3. Excel will automatically select the range of cells that it thinks you want to sum. If this range is incorrect, simply click and drag to select the correct range of cells.
4. Instead of pressing Enter to insert the SUBTOTAL function, press Shift+Enter. This will force Excel to insert a SUM function instead.

Alternatively, you can also use the

Code:

=SUM(

function directly by typing "

Code:

=SUM(

" and then selecting the range of cells that you want to sum. This will give you the same result as using the AutoSum button, but without the risk of Excel trying to be too smart.

I hope this helps you get the results you need without having to manually type the SUM function every time. Let me know if you have any other questions!