autosum

[capital me]

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]

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)

 

[Dave Peterson]

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.

 

[M Thompson]

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..