That's what I was afraid of.

It is confusing. You've set up your demo exactly how my spread is (Except
for all the data in the columns between). Do you think that because there
are text columns, % columns, number columns and blank columns that lie in
between, that this may be causing the confusion??? I'm at a loss.

Thanks for all you help.

"JE McGimpsey" wrote:

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???