[libreoffice-users] Calc. extract values

2015-07-27 Thread HBarr
Hi, 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. Help greatly appreciated. Hbarr -- To unsubscribe e-mail to: users+unsubscr...@global.libr

Re: [libreoffice-users] Calc. extract values

2015-07-27 Thread Brian Barker
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