Hi,

This is my first post, can anyone please help?

I need to add all the values in rows based on one criteria and columns for the other criteria... meaning, all sold kilos for December, all received kilos for November etc.

eg.

Financial Week 20 21 22 23
Month Nov-13 Nov-13 Dec-13 Dec-13

Sold KG - Mod 6 16,214 31,077 32,606 34,050
Sold KG - Mod 8 413 825 825 866
Sold KG - Mod 12 1,550 4,420 2,900 3,256
Sold KG - Mod 24 586 1,172 1,172 1,230
Received Mod 6 16,233 31,113 32,643 34,088
Received Mod 8 413 826 826 867
Received Mod 12 1,552 4,425 2,904 3,260

I have attached my file Sum issue.xlsx

Thank you