Re: [libreoffice-users] Need help with a calculation for an auction

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