Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.