[libreoffice-users] Re: Calc question

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+unsubscribe@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