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

#### The Grim Discovery

##### Board Regular
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>

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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")

Cheers, MM

Replies
4
Views
429
Replies
4
Views
443
Replies
10
Views
884
Replies
0
Views
303
Replies
30
Views
2K

1,196,312
Messages
6,014,594
Members
441,828
Latest member
cofracr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back