Calc question

users
#1

I'm going to use Calc for recording sales during an auction.

When all data has been entered, I will sort on the names of the buyers.
For any given buyer there will be N entries (where N > 1).

Next to each buyer will be a price. How do I total the amount of a
buyer's purchase "on the fly", so-to-speak?

Thanks.

#2

Jim Trigg / Blaise de Cormeilles has written on 1/23/2014 9:54 PM:

I'm going to use Calc for recording sales during an auction.

When all data has been entered, I will sort on the names of the buyers.
For any given buyer there will be N entries (where N > 1).

Next to each buyer will be a price. How do I total the amount of a
buyer's purchase "on the fly", so-to-speak?

Well, it will give you N answers for each buyer, but if the buyer's name
is in column A and the price is in column B, then
SUMIF($A$1:$A$###,A1,$B$1:$B$###) in cell C1, with ### replaced by the
last row and the formula then copied down to the remaining cells, will do
it.

I was hoping that there was a way to select the several "price" cells
and then click on something. The people using Calc will probably never
have seen a spreadsheet before.

Thanks.

#3

Once you're ready to get your totals by buyer
1) sort by buyer as you intend
2) select the entire data range including the column labels
3) from the menu select "Data | Subtotals..."
4) in the Subtotals dialog box make sure the "Group by" option is "Buyer"
5) tick the "Price" check box in the "Calculate subtotals for" list
6) confirm "Sum" is the selected function in the "Use function" list
7) click the "OK" button

You'll be back to your spreadsheet with subtotals for each Buyer inserted.
Plus to the left of the row numbers you'll see outline features that allow
hiding and showing the various subtotaled rows.

-Alan

#4

Well, it will give you N answers for each buyer, but if the buyer's name
is in column A and the price is in column B, then
SUMIF($A$1:$A$###,A1,$B$1:$B$###) in cell C1, with ### replaced by the
last row and the formula then copied down to the remaining cells, will do
it.

Jim Trigg

#5

Alan B has written on 1/23/2014 9:58 PM:

Have labels at the top of each column such as Buyer and Price.

Once you're ready to get your totals by buyer
1) sort by buyer as you intend
2) select the entire data range including the column labels
3) from the menu select "Data | Subtotals..."
4) in the Subtotals dialog box make sure the "Group by" option is "Buyer"
5) tick the "Price" check box in the "Calculate subtotals for" list
6) confirm "Sum" is the selected function in the "Use function" list
7) click the "OK" button

You'll be back to your spreadsheet with subtotals for each Buyer
inserted. Plus to the left of the row numbers you'll see outline
features that allow hiding and showing the various subtotaled rows.

Wow!!! That's terrific!!!

Thanks so much!

#6

Hi :slight_smile:
I think the answer you liked is below

Pikov Andropov wrote