I've read through this thread and find myself somewhat confused.

You mentioned the second criteria was giving you the problem. My
understanding is that the second criteria has to do with Column I.

However, when I asked for the formula, it looks like the formula you
posted has to do with Column H.

Can you please clarify?

By the way, in your first post you mentioned that the formula returned
#NUM!. Does your range contain #NUM! values? You can test it by trying
the following...

=COUNTIF(Range,#NUM!)

In article <6d915c756aa8d@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi Domenic,

Thanks for further input. Answered questions below.

Cheers,
Sam

Domenic wrote:
It looks like SUMPRODUCT returns 0 because your formula...

=IF(ISERR(B5:F5),"",CONCATENATE(COUNTIF($B5:$F5," <=205"),"/",COUNTIF($B5:$F5"
205")))

...will always return a text string. If I understand correctly, the intent
of the formula is as follows:

1) check B5:F5 for error values, other than #N/A,

Yes

2) if an error value exists, leave the cell blank

Yes

3) if an error value does not exist, divide the number returned by the
first COUNTIF formula by the number returned by the second COUNTIF
formula.

No, not divide. I'm using CONCATENATE with the forward slash "/" as a joiner
/ separator between the first COUNTIF result and the second COUNTIF result.

If this is correct, try...

=IF(OR(ISERR(B5:F5)),"",COUNTIF($B5:$F5,"<=205" )/COUNTIF($B5:$F5,"205"))

...confirmed with CONTROL+SHIFT+ENTER. Does this help?