I'm attempting to determine the standard deviation for a set of data points that must satisfy two requirements. The precise example is: It is necessary to determine the yield standard deviation for the crop variety "Z1" in region "A." A list of a few thousand yields, together with their matching area and variety, is available. The results should be the standard deviation for the three values (1500, 1800, and 1600) in the table below that satisfy this requirement. All other yields should be disregarded.

```Region  Variety Yield
A   Z1  1500
B   Z1  2100
B   X2  1900
A   X1  1700
C   Z2  2000
C   X1  1500
A   Z1  1800
B   Z2  2500
C   X1  1700
A   Z1  1600
```

I tried using this formula, but it does not work (also not as an array formula) and only returns "FALSE"

`=IF(AND(Region="A",Variety="Z1"),STDEV.S(Yield))`

Dec 16, 2022 in Others 259 views

## 1 answer to this question.

I would say:

```=STDEV.S(IF((A2:A11="A")*(B2:B11="Z1"),C2:C11,""))
```

Array entered.

• 63,420 points

## Change Data Source Range for ALL Pivot Tables that are Using a Particular Named Range Within Excel via VBA

Try this: Sub Tester() Dim ...READ MORE

## Excel: How to analyze data in a table that contains multivalue cells

The below formula will create a unique ...READ MORE

## How can I allow a user to change a cell in excel only under particular conditions?

Copy the next event code in the ...READ MORE

## Excel VBA function that cross references two data sets to come up with one solution

Solution using dictionary to count Public Sub citizens() ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE