Total countif to include a 'no' which is really a 'yes'

[The Grim Discovery]

Hello people

Your help would be appreciated. I'd like to adjust the formula in A1 to accommodate a countif anomaly.

The total in A3 = countif of 'yes' in A10:A30
The total in A4 = countif of 'no' in A10:A30

The problem is that I need to extend the formula to include data from row 31. But in row 31 'yes' and 'no' effectively change values so a 'no' should be added the total in A3 and 'yes' to the total in A4. Is there a tidy way of expressing this in a formula?

	A	B	C
1	70% (A3/A3+A4)%
2
3	14
4	6

<tbody>
</tbody>

 

[Momentman]

For your YES countif, you can use =COUNTIF($A$10:$A$30,"yes")+(A31="yes") and similarly for the NO =COUNTIF($A$10:$A$30,"no")+(A31="no")

 

[The Grim Discovery]

Cheers, MM