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

Reply via email to