Hi All,

I have a formula which I am trying to calculate the level of conformance.

This works well:

=IFERROR(COUNTIF(C18:C21,"Conformance")/SUM(COUNTIF(C18:C21,{"Non-conformance","Conformance"})),"NA")

However when i get to the situation where there is an array of ranges it doesn't work so well:

=IFERROR(COUNTIF({C24:C26,C28:C29,C31:C34},"Conformance")/SUM(COUNTIF({C24:C26,C28:C29,C31:C34},{"Non-conformance","Conformance"})),"NA")

Note that what is between the ranges is NOT a blank cell.

Does anyone have any advice?