Sumproduct or Sum If??

  • Thread starter Thread starter sh0t2bts
  • Start date Start date
S

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 :o)
 
Hi
you could use SUMPRODUCT but I would recommend to create a
pivot table based on your source data for this
 
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
 
Back
Top