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