Hi :) I think the answer you liked is below
Pikov Andropov wrote > 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! -- View this message in context: http://nabble.documentfoundation.org/Calc-question-tp4093716p4095949.html Sent from the Users mailing list archive at Nabble.com. -- 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