Sum for date range where columns are individual days and criteria can be in multiple rows

[leonp]

Hello,

I’m trying to determine if there is a formula I can use that will be able to dothis.

The columns in my spreadsheet represent individual dates(e.g. column B is 01/09, C is 02/09, etc). for each date there are quantities andin column A there is a product code. Each product code can repeat in multiple rows.

If that is sheet1 and in sheet2, I have a from date (let’ssay in A1) and a to date (A2), is there a way to sum the total quantity for agiven product code based on the date range entered? I.e. I will need to sum every occurrence ofthe product in multiple columns.

Thanks!

 

[Fluff]

With sheet1 like

Book1
	A	B	C	D	E	F
1	Product	01/09/2019	02/09/2019	03/09/2019	04/09/2019	05/09/2019
2	E05004799
3	E05004785	1	2	3
4	E05004802
5	E05004787
6	E05004785	1	2	3
7	E05011061
Sheet1

In sheet2

Book1
	A	B
1
2	01/09/2019	02/09/2019
3	E05004785	6
Sheet2

Cell Formulas
Range	Formula
B3	=SUMPRODUCT((Sheet1!B1:T1>=A2)*(Sheet1!B1:T1<=B2)*(Sheet1!A2:A15=A3),Sheet1!B2:T15)