SUMIF formula help

[Jobb1Excel]

Hey, i need some help with the SUMIF formula.
i got a sheet with product material numbers and i want to lookup the material numbers in a sales sheet.

Example:

The picture is from the sales sheet and lets say i want to look up "material nr 1" in the other sheet and criteria to be material nr 1 is a match and date is 4 weeks in the past - 2 weeks from today, so if those criterias is met then SUM all the QTY's found with that material number and those dates. So the output should be 200 in this example, but lets say the line with material nr 4 was material nr 1 then the output would have been 200 + 4 so "204".

 

[Jobb1Excel]

Im also looking for a formula that outputs every line that is a match and meet the criterias and the date
i will be using the same example as above.
Looking up "Material Nr 1"

Output:

this formula is for the same thing as above. So i get one cell with the total and then each order qty with the deliv date in the cells below the total cell.

 

[RoryA]

You could do something like:

=VSTACK(SUMIF(E:E,"Material Nr 1",G:G),FILTER(G:H,E:E="Material Nr 1"))

For future reference, it's a lot simpler for people to help if you post tables of data (eg using the XL2BB tool) rather than pictures.

 

[Jobb1Excel]

Hey, the "material nr 1" is just an example. "The material nr 1" is gonna be a cell reference to cell A2 in the main sheet (=A2). I would have been using XL2BB tool if i could, but it is not working for me.

 

[RoryA]

Then just replace "Material Nr 1" with A2 in the formula.