Re: [libreoffice-users] Calc question

On Thu, January 23, 2014 9:28 pm, Pikov Andropov wrote:
> 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.

Jim Trigg


-- 
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