Need help with a calculation for an auction

users
#1

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.

#2

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

#3

Hi :slight_smile:
You can find all your previous threads in Nabble at
http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodes&user=486624

If that doesn't work then just get into Nabble and click on the icon that is
beside your name. Pikov's is currently a grey person, just head&shoulders.
I've set mine to a fiery fox with many thanks and respects to artists in
DeviantArt for release such things under copyleft licenses.
Regards from
Tom :slight_smile:

#4

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

#5

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 convenient and versatile.

Best,
Joel