Count problem

  • Thread starter Thread starter L-O
  • Start date Start date
L

L-O

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
 
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
 
Hi,
use the formula given before or try

=COUNTIF(A1:G1,NA())

change range to fit your needs
 
Thank you Jacob!!! It actually worked. I thought I wrote in a confuseing
manner, but you understood. Excellent!!!
 
Back
Top