Count problem
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
|