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 <piko...@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+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
