Sumproduct or Sum If??

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 :eek:)
 
F

Frank Kabel

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top