Countif text and ignore the formula in the cells

[Rumpkin]

Is there a way to count the number of occurances in a range that are alpha numeric and the result of the formula that is in each cell within the range?

Thanks in advance

 

[Scott Huish]

Can you give some samples of what you are trying to count exactly?

 

[Rumpkin]

I have put it in my dropbox. This is just a portion for review, not the entire workbook.
If you cannot get to this, let me know another way to post it. - - Thanks!
https://www.dropbox.com/s/iet1dum28y14hdg/book1.xlsm?dl=0

 

[jtakw]

Hi,

Your current formula in I6: =COUNTA(B8:B42)-1-COUNTIF(B9:B42,0)

You can do this, it's not necessarily better, just another way: =COUNTIF(B8:B42,"=*")-1

 

[Scott Huish]

I agree with that, although the = isn't necessary, it's the default.

=COUNTIF(B8:B42,"*")-1

 

[Rumpkin]

Thanks to Scott & jtakw.
That is exactly what I needed, to simplify it.
The less it calculates the better!!

Regards,

 

[jtakw]

You're welcome.