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

Let's not forget the Pivot Table option, though I know that wasn't the 
option you were thinking of.


On 2/6/14 5:17 PM, Paul wrote:
> 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