COUNTIF() requires a contiguous range, so AFIAK, you can't use it for
your purposes.

The confusing thing is why it isn't recognizing the values as numbers
0. You might want to take a look at my test workbook:

ftp://ftp.mcgimpsey.com/excel/renee_demo.xls


In article ,
Renee - California wrote:

Is there no way to do a countif 0 on all those cells??? If I can get that,
then I can just () the original set, and divide by that countif formula....
right???