To exclude certain cells from the auto-sum, you can subtract them from the auto-sum. For example, if you are calculating the sum of A1:A10 and want to exclude A4:A6, then you can write =SUM(A1:A10)-SUM(A4:A6)