Standard Deviation based on multiple criteria

[cglor]

I need to calculate the standard deviation based on two criteria. Criteria 1: Date Range. The sample must fall between two years. Criteria 2: Sample must be labeled as NV.

I have well over 7000 samples so here is just a very small sample.

For example, I would like to find the standard deviation of all Samples that are labeled as NV between the years 1999 and 1970.

Breakdown

A	B	C	...D
Date	NV or V	Sample	Year Range
1998.5	V	.5	1999
1998	NV	.6	1998
...	...	...	...
1980.6	V	.3	1980
1979.2	NV	.5	1979
1974	NV	.1	1978
1970.1	NV	1.01	1975
1960	V	1.09	1960

<tbody>
</tbody>

Here is something that I tried to use, but as a regular formula, it returned a #DIV ! error. As an array it returned a #REF ! error. Note this doesn't have the "NV" criteria. I was just trying to see if the formula would return anything.

=STDEV.S(IF((a$3:a$7023>=d4)*(a$3:a$7023<d3),c$3:c$7023))

Any helpful hints would be appreciated. One would think that Microsoft would have come up with a STDEVIFS function by now.

Thanks a bunch!

 

[cglor]

=STDEV.S(IF((a$3:a$7023>=d4)*(a$3:a$7023<d3),c$3:c$7023)) THis didn't completely display on the first post. Whoops!