Also, if you want to total everything in a column or a row adjacent to where you want the total, press the Alt key and the Equal sign key and hit enter. Always go back and check your formula to make sure it did what you wanted it to do.
> -----Original Message----- > From: Jfw [mailto:[email protected]] On Behalf Of Anna > Byrne via Jfw > Sent: Tuesday, June 03, 2014 9:52 AM > To: The Jaws for Windows support list. > Subject: Re: question about excel > > 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 _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
