Calc. extract values

users
#1

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

#2

If I understand you correctly,
=SUMIF(C2:C2000;"Item name";D2:D2000)

I trust this helps.

Brian Barker

#3

Substitute the term "Data Pilot" with "Pivot Table".