Ignoring cells in a countif formula

[TheNeighbour]

Hey!
I am trying to see percentage of "true" cells in a column, but I want to ignore a few rows/cells along the way. Like for example I want to see which in the following are true (B67:B74) but NOT count with (B71:B72).

Before excluding B71:B72 I am using =(Countif(B67:B74,True)/COUNTA(B67:B74)), which gives the result I want with a percentage changing as I tick or untick a cell for true/false.

Then I've experimented and realized that =(COUNTIF(AND(B67:B69,B72:B74), True)/Counta(AND(B67:B69,B72:B74))) works fairly fine in the first step of avoiding B70 & B71, but then it doesn't calculate the percentages of the resuming cells' "true".

Could someone help me with what the formula should look like for this issue?

 

[Versonol]

Try using this formula =(COUNTIF(B67:B74, TRUE) + COUNTIF(B72:B74, TRUE))/(COUNTA(B67:B74) + COUNTA(B72:B74))

 

[bebo021999]

= sum of true (whole range)- sum of true (excl. range)
then divide to
rows count (whole range)- rows count (excl. range)

Then should be:

=(SUMPRODUCT(--B67:B74)-SUMPRODUCT(--B70:B71))/(ROWS(B67:B74)-ROWS(B70:B71))

 

[TheNeighbour]

Thank you both! Versonol's formula =(COUNTIF(B67:B69, TRUE) + COUNTIF(B72:B74, TRUE))/(COUNTA(B67:B69) + COUNTA(B72:B74)) got the result I was looking for, so I will stick to this one!

Have a good one!