At 15:39 28/07/2015 +0900, Howard Barr wrote:
I have calc sheet with 4 columns A1 is Date, B1 is Vendor, C1 is Item, D1 is Cost. I would like to extract the accumulated expenditure of an item and display it in F1. There are over 1,000 items.
If I understand you correctly, =SUMIF(C2:C2000;"Item name";D2:D2000) I trust this helps. Brian Barker -- 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