I think just count(a1:a5000) will work as it ignores errors?



"dhstein" wrote:

Is there a way to use Countif to count the number of cells in the range that
are not errors - in other words - they are NOT #VALUE and NOT #DIV 0 etc.

=COUNTIF(A1:A5000, ??????)