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