Using your specific conditional formatting formula requires an array entered solution:

Array enter (`Ctrl`+`Shift`+`Enter`) the following formula in `D2`

(don't forget to remove the `{`

and `}`

):

```
{=SUM((B2:B50>500)*IFERROR((SEARCH("A",C2:C50)=1),FALSE))}
```

As this is an array entered formula, an array is generated for each of the ranges `B2:B50`

and `C2:C50`

, with the array values being the results of the respective comparisons for each row.

The key thing to understand is that, when multiplied, a `TRUE`

value is converted to a `1`

, and a `FALSE`

value to a `0`

. Thus the array generated by the multiplication of the two arrays will contain elements with a value of `1`

if and only if *both* the `B`

column is greater than 500 and the `C`

column starts with an "A". (Otherwise, the element value will be a `0`

.)

Summing the array leads to the count of the rows where both conditions are true.

Rather that checking to see if the index of the first letter "A" found of the value in the `C`

column is "1", a better solution would be to check if the first character is an "A", directly:

```
{=SUM((B2:B50>500)*(LEFT(C2:C50,1)="A"))}
```

With the formula in this new format, and being aware that the `COUNTIFS()`

function can use wildcards, it becomes obvious that a non array entered alternative solution is:

```
=COUNTIFS(B2:B50,">500",C2:C50,"=A*")
```