Alan B has written on 1/23/2014 9:58 PM: > > Have labels at the top of each column such as Buyer and Price. > > Once you're ready to get your totals by buyer > 1) sort by buyer as you intend > 2) select the entire data range including the column labels > 3) from the menu select "Data | Subtotals..." > 4) in the Subtotals dialog box make sure the "Group by" option is "Buyer" > 5) tick the "Price" check box in the "Calculate subtotals for" list > 6) confirm "Sum" is the selected function in the "Use function" list > 7) click the "OK" button > > You'll be back to your spreadsheet with subtotals for each Buyer > inserted. Plus to the left of the row numbers you'll see outline > features that allow hiding and showing the various subtotaled rows.
Wow!!! That's terrific!!! Thanks so much! -- 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