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.

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.

If I collect the data in to file no 2
What do you mean by collect data?


If you are looking at counting entries other than errors; try the below..
=COUNTA(A1:A25)-SUMPRODUCT(--(ISERROR(A1:A25)))

If this post helps click Yes
---------------
Jacob Skaria


"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.

I mean that I retrieve by using vlookup-formula into the 2nd file. Which is
the file I actually work in. The 1st file is supplied to me.

Thanks, L-O

"Jacob Skaria" wrote:

If I collect the data in to file no 2
What do you mean by collect data?


If you are looking at counting entries other than errors; try the below..
=COUNTA(A1:A25)-SUMPRODUCT(--(ISERROR(A1:A25)))

If this post helps click Yes

Hi,
use the formula given before or try

=COUNTIF(A1:G1,NA())

change range to fit your needs

"L-O" wrote:

I mean that I retrieve by using vlookup-formula into the 2nd file. Which is
the file I actually work in. The 1st file is supplied to me.

Thanks, L-O

"Jacob Skaria" wrote:

If I collect the data in to file no 2
What do you mean by collect data?


If you are looking at counting entries other than errors; try the below..
=COUNTA(A1:A25)-SUMPRODUCT(--(ISERROR(A1:A25)))

If this post helps click Yes

Thank you Jacob!!! It actually worked. I thought I wrote in a confuseing
manner, but you understood. Excellent!!!

"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.