Indeed - I was blown away about 10 years ago when I found out how great pivot tables can be and this seems like a great case of using them, here is a simple youtube video in less than a minute and a half shows you how to make one:
http://www.youtube.com/watch?v=BxC3rVeFxnw Super powerful, very convenient and versatile. Best, Joel On 02/06/2014 05:22 PM, Carl Paulsen wrote: > Let's not forget the Pivot Table option, though I know that wasn't the > option you were thinking of. > > > On 2/6/14 5:17 PM, Paul wrote: >> 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 <[email protected]> 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: [email protected] 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
