reply below Debora Cass wrote: > > I am using version 2.1 of Openoffice.org. My problem is that I can not > get the auto sum function to work. I put numbers in a column and then > highlight the numbers to be totaled by click on the sum icon. All it does > is put =sum() on my first row in the column. I also went to Edit - Fill > and the sub-menu is greyed out so, I can not select anything from that > list. > > How do I get this to work. > > Debora Cass > Library Senior > TNT Division > (928)692-5715 > Ext:5715 > >
I've never used autosum or its equivalent in a spreadsheet. As you can see from the previous answers, its use is limited. First, your total has to go below the items to be summed and, secondly, the column must be continuous. For any other situation, select the cell where you want the total, type =SUM( select the items you want to total and type the closing ) and enter. You can use the autosum button the same way for all the good it does. Why it's an indispensable part of the formula bar is beyond me. -- View this message in context: http://www.nabble.com/I-can-not-get-autosum-to-work-tf3040797.html#a8461677 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
