Counting non-error cells

[stepan1987]

Hi, which formula do I use to count non-error cells?
And which formula helps me to count non-error cells which are less that prespecified value?

Thanks!

 

[crook_101]

Hi,

Q1 - You can use ISERROR() to identify error cells..without seeing your data cannot say how to incorporate this though, you may have to count all good cells and subtract errors?!?

Q2 - err think I know what you are after but once again, some detail may support a better reponse.


Ian

 

[jim may]

Hi, which formula do I use to count non-error cells?

In a given Range of Cells, or an entire worksheet?

And which formula helps me to count non-error cells which are less that prespecified value?

In a given Range of Cells, or an entire worksheet? AND testing ONLY formula Cells?

 

[stepan1987]

Thanks for the response guys, I ve already figured it out. I used simple COUNT() for the first one - it excludes errors automatically.
For the second one I used COUNTIF(range,"<"&B1) where B1 has the needed value