product equation for specific date range

[etsh13]

i am trying to use the product equation to product some values from certain date rang, i was thinking maybe there is some-sort of productif equation or so.

thanks in advance

 

[paulm88]

I'm not sure if the following is what you're looking for. This will allow you to input dates in E3 & E4. The formula in E5 will return the sum of the values in column B that are including and between these two dates in column A.

Excel 2013 64 bit

	A	B	C	D	E
1
2	DATE	VALUES			DATE RANGE
3	01/02/2019	10		START	01/02/2019
4	02/02/2019	15		END	09/02/2019
5	03/02/2019	20		VALUE	140
6	04/02/2019	25
7	05/02/2019	20
8	06/02/2019	20
9	07/02/2019	15
10	08/02/2019	10
11	09/02/2019	5
12	10/02/2019	0
13	11/02/2019	15
14	12/02/2019	20
15	13/02/2019	30

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula E5 =SUMIFS([COLOR=rgb(255]B3:B15,A3:A15,">="&E3,A3:A15,"<="&E4[/COLOR]) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[etsh13]

first of all, thanks for your reply.
your method will work if i am trying t sum the values, but i actually want to my multiply the values, so the result value for your data from 1/2/2019 to 9/2/2019 to be

22,500,000,000

<tbody>
</tbody>

 

[Dave Patton]

Excel 2010
	A	B	C	D	E
1	DATE				DATE RANGE
2	1-Feb-19	10		START	1-Feb-19
3	2-Feb-19	15		END	9-Feb-19
4	3-Feb-19	20
5	4-Feb-19	25		Product	22,500,000,000
6	5-Feb-19	20		Product	22,500,000,000
7	6-Feb-19	20
8	7-Feb-19	15
9	8-Feb-19	10
10	9-Feb-19	5
11	10-Feb-19	0
12	11-Feb-19	15
13	12-Feb-19	20
14	13-Feb-19	30
15
3a

Cell Formulas
Range	Formula
E5	=PRODUCT(B2:B10)
E6	=PRODUCT(INDEX(B:B,MATCH(E2,A:A)):INDEX(B:B,MATCH(E3,A:A)))

 

[etsh13]

that is exactly what i need, thank you very much

 

[Dave Patton]

Thanks for the feedback. Dave