I seem to recall your question, and I think you're looking for Subtotals under the Data menu.
1. Sort by name 2. Subtotals on the Data menu Paul On Thu, 06 Feb 2014 17:04:15 -0500 Pikov Andropov <piko...@gmail.com> wrote: > 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
