Hi There,
I'm also having difficulty with this type of formula, I suspect I just have the parentheses out of order? as this will return the result I require but it displays the #div/0 error instead of "".

I'm wanting the formula to display the results if there is no error or if G3 isn't blank.
This code uses values in table headings then counts the values on the data tab.


=IF(OR(ISERROR(COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|Breach"))/(COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|Breach")+COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|No Breach")),(ISBLANK(G$3))),"",(COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|Breach"))/(COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|Breach")+COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|No Breach")))


Any help would be appreciated