Hi,
try

=SUM(0+ISNA(A1:G1))

change range to fit your needs

"L-O" wrote:

I have one excel-file that contains some values; ABC, CBA, AAA etc.
Then I have another file which contains all of these values and more (its
actually text). If I collect the data in to file no 2 the text that does not
exist in the first file, but exists in the 2nd file, will become error-values
in the cell. That is fine, but how do I tell them apart when I want to count
the ones that return real values, but not the ones with error-messages? The
count-formulas I have found either counts both errors and values or none.