I thought I had posted this earlier today but as it hasn't shown up, I must have hit the wrong button!
Someone had an elegant solution to this problem but I've lost it. I have a spreadsheet with the following columns: Name, Amount, Item #, Description. It's for an auction. When the auction is over and all data has been entered, the cashier needs to tally the amount each person owes. My wife came up with this: 1. Sort on Name 2. Manually insert an empty row after each name group. 3. For each person, swipe from the top entry in Amount to that person's last entry. 4. Click SIGMA The total for that person will appear in the Amount column in the heretofore empty row under that person's name group. The solution I lost did all the calculations at once. Sound familiar? Thanks. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted