Sumproduct or Sum If??

[sh0t2bts]

I am trying to sum some invoice data covering the last 5 years, the columns
I have are:-

Supplier_No, Date_Received , Received_Value


There are 12 "but not always" entries per Supplier_No Per Year.

What I want to do is sum a total "Received_Value for each year for each
supplier_no:-

2004 Supplier_ID, Received_Value
2003
2002
2001
2000


I can use sumif for the supplier_Id to get a grand total but what would I
use for sum if Date is in Year 2000, and then for 2001, 02, 03 ,04??


Many Thanks

Mark )

 

[Frank Kabel]

Hi
you could use SUMPRODUCT but I would recommend to create a
pivot table based on your source data for this

 

[sh0t2bts]

I would like the values in a Cell as a result of a formula as it is linked
into by other workbooks and the data changes depending on which raw file I
use.

Could you advised on how I would do a sumproduct to sum the receieved value?

I have managed to doa some product to cound the number of entries for each
supplier_no for each year I just can't get it to sum the value


Cheers

Mark

 

[Frank Kabel]

Hi
see for SUMPRODUCT usages:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[sh0t2bts]

Thanks I found all that i neded )

Hi
see for SUMPRODUCT usages:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html