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?
Bookmarks