Either exclude them from the formula:

=sum(a1:a3,a6:a10)
or sum everything, then subtract what you want:
=sum(a1:a10)-sum(a4:a5)
or
=sum(a1:a10,-a4,-a5)



capital me wrote:

can anyone show me how to exclude cells in autosum...
I am trying to add a column of numbers together on a spread sheet. But there
a few specific cells I do not want to include in the totals.. is there a way
to do this?

--

Dave Peterson