SUM values from different rows and collumns with more then one condition

[pjinacio]

Hi,

I have this sample of a table from which I want to collect the quatities from the different product references (ACB 1 to 7) using the date also as a condition.

You can see that in the posted picture i have the table with the source of information and the table below the result that i need to have but my problem is how to do it in a easy way without macros because i never worked with macros.




-- removed inline image ---

 

[Excelestial]

Your table didn't show...but ifyou're using Excel 2007 or newer, use SUMIFS. If using an earlier version of Excel...use SUMPRODUCT.

 

[pjinacio]

-- removed inline image ---

 

[pjinacio]

I tried to past the image but when I submit reply it disappears.

Can someone help me or can i attach the excel file??