I think I've managed to get around this with COUNTIF. I just use COUNTIF in the dynamic range -- the cells with #N/A are not counted.

Thank you for your help,

-DanE