Jim Trigg / Blaise de Cormeilles has written on 1/23/2014 9:54 PM: > 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.
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. -- 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
