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
DATE	VALUES

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] "]DATE RANGE[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]01/02/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: center"]START[/TD]
[TD="align: center"]01/02/2019[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]02/02/2019[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: center"]END[/TD]
[TD="align: center"]09/02/2019[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]03/02/2019[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: center"]VALUE[/TD]
[TD="align: right"]140[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]04/02/2019[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]05/02/2019[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]06/02/2019[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]07/02/2019[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]08/02/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]09/02/2019[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]10/02/2019[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]11/02/2019[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]12/02/2019[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]13/02/2019[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]E5[/TH]
[TD="align: left"]=SUMIFS([COLOR=rgb(255]B3:B15,A3:A15,">="&E3,A3:A15,"<="&E4[/COLOR])[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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 [TABLE="width: 126"]
<tbody>[TR]
[TD="class: xl63, width: 126"]22,500,000,000[/TD]
[/TR]
</tbody>[/TABLE]

 

[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