How to count number of cells with only ZEROS!

[Ultimate Selector]

I am stumped a bit on this one. I want to count the number of cells that have a ZERO (0) in them.
I do NOT want to count any blank cells, just the cells that contain a 0 in them within a range.

What is the formula for this?

Thanks in advance for any help on this!

Regards,
U.S.

 

[My Aswer Is This]

You earlier said if they are 0 now your saying if they are blank.
Formatting does not change the value in the cell.

This is my data layout ...

[TABLE="width: 468"]
<tbody>[TR]
[TD][/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]1 2[/TD]
[TD]1 2 3[/TD]
[TD]1[/TD]
[TD]1%[/TD]
[TD]1234[/TD]
[TD]5 10[/TD]
[TD]2%[/TD]
[TD]3%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]86[/TD]
[TD][/TD]
[TD][/TD]
[TD]#1[/TD]
[/TR]
[TR]
[TD]#2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]98[/TD]
[TD][/TD]
[TD][/TD]
[TD]#2[/TD]
[/TR]
[TR]
[TD]#3[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]15[/TD]
[TD]87[/TD]
[TD][/TD]
[TD]10[/TD]
[TD]#3[/TD]
[/TR]
[TR]
[TD]#4[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]85[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]#4[/TD]
[/TR]
[TR]
[TD]#5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16[/TD]
[TD]93[/TD]
[TD][/TD]
[TD][/TD]
[TD]#5[/TD]
[/TR]
[TR]
[TD]#6[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD]31[/TD]
[TD]73[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]#6[/TD]
[/TR]
[TR]
[TD]#7[/TD]
[TD]5[/TD]
[TD]14[/TD]
[TD]64[/TD]
[TD]87[/TD]
[TD][/TD]
[TD][/TD]
[TD]93[/TD]
[TD]11[/TD]
[TD]64[/TD]
[TD]24[/TD]
[TD]#7[/TD]
[/TR]
[TR]
[TD]#8[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]91[/TD]
[TD]100[/TD]
[TD]20[/TD]
[TD]91[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD]10[/TD]
[TD]#8[/TD]
[/TR]
[TR]
[TD]#9[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD]29[/TD]
[TD][/TD]
[TD][/TD]
[TD]55[/TD]
[TD]47[/TD]
[TD][/TD]
[TD]29[/TD]
[TD]#9[/TD]
[/TR]
[TR]
[TD]#10[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]41[/TD]
[TD]65[/TD]
[TD]2[/TD]
[TD]9[/TD]
[TD]86[/TD]
[TD]21[/TD]
[TD]32[/TD]
[TD]24[/TD]
[TD]#10[/TD]
[/TR]
</tbody>[/TABLE]



* I want to count the number of cells that are blank. They do have zeros however but I blanked them out in my formatting.
The COUNTBLANK statement does not work either.

 

[Ultimate Selector]

Use this:
=COUNTIF(K28:T28,0)

We gave you example. Not knowing the range

I did use that range.

 

[Ultimate Selector]

You earlier said if they are 0 now your saying if they are blank.
Formatting does not change the value in the cell.

I was just explaining my data below. I understand that formatting does not change my zero value.
I didn't want anyone to think there were blanks here!.

 

[Ultimate Selector]

Ok Booo Yaaa! I finally got it to work correctly!

Thank You all for your help and responses! Much Appreciated!