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