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