You need a formula to include everything you want totaled. For
example, if you want cells b2 through b20 totaled, you would type the
following:
=sum(b2:b20)
THIS MEANS
= -- The equal sign tells Excel that the following is a formula.
sum -- this is a function telling Excel to total the numbers in parenthesis
(b2:b20) -- add up the cells joined by the colon, including
everything along the way.
b2+b3+b4+b5+ etc.
If you want to total cells not adjacent to each other, join them by
commas. So b2 + b3 + d4 would be
=sum(b2,c3,d4)
Good luck!
_______________________________________________
Jfw mailing list
[email protected]
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com