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

2014-02-06 Thread Pikov Andropov
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

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

2014-02-06 Thread Paul
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

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

2014-02-06 Thread Carl Paulsen
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

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

2014-02-06 Thread Joel Madero
Indeed - I was blown away about 10 years ago when I found out how great pivot tables can be and this seems like a great case of using them, here is a simple youtube video in less than a minute and a half shows you how to make one: http://www.youtube.com/watch?v=BxC3rVeFxnw Super powerful, very