STDEV.P for multiple criteria

[genkinbaku]

hello - I'm trying to get a formula to figure standard deviation based on criteria in corresponding cells. The sheet I'm using needs to calculate the STDEV.P for cells matching value between certain date criteria.

In this example, I'd like to calculate the STDEV.P of column B as long as the dates in corresponding column A is between 01/02/20 00:00:00 to 01/03/20 00:00:00

 

[AhoyNC]

If your version of 365 has the FILTER function try the formula in D4 below. If not then the formula in D6.

Book1
	A	B	C	D	E
1	Time	Value.		Start Date	End Date
2	1/1/2020 12:00	450		1/2/2020 0:00	1/3/2020 0:00
3	1/1/2020 18:00	399		STDEV.P
4	1/2/2020 0:00	650		244.30
5	1/2/2020 6:00	450
6	1/2/2020 12:00	111		244.30
7	1/2/2020 18:00	850
8	1/3/2020 0:00	541
9	1/3/2020 6:00	632
10	1/3/2020 12:00	658
11	1/3/2020 18:00	41
12	1/4/2020 0:00	985
13	1/4/2020 6:00	655
14	1/4/2020 12:00	741
15	1/4/2020 18:00	254
16	1/5/2020 0:00	250
Sheet2

Cell Formulas
Range	Formula
D4	D4	=STDEV.P(FILTER(B2:B16,($A$2:$A$16>=$D$2)*($A$2:$A$16<=E2),""))
D6	D6	=STDEV.P(IF($A$2:$A$16>=$D$2,IF($A$2:$A$16<=$E$2,$B$2:$B$16)))

 

[maabadi]

Welcome to MrExcel Message Board.
Use this with CTRL+SHIFT+ENTER

=STDEVP(IF(A2:A19>=$A$2,IF(A2:A19<=$A$14,B2:B19,"")))