autosum
 

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?

autosum
 

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

autosum
 

Another way is to use a helper column to indicate if the number in the first
column should be summed:

=sumif(b1:b10,"x",a1:a10)

Sum the quantities in A1:A10 only if B1:B10 is equal to X.



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

autosum
 

You can click the autosum button, then click in the uppermost or the
lowermost cell. At this point hold the control button down and drag or click
through the cells you need to include.

Hope this helps..
--
OneFineDay


"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?