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.

 

[Eric W]

Try:

=COUNTIF(A:A,0)

 

[Ultimate Selector]

I already tried that and no go! But Thanks for your response!

 

[My Aswer Is This]

If the range you want to check is D1 To D10
Try this:
=COUNTIF(D1:D10,0)

 

[Eric W]

What do you get when you try it? I've tried it, and so has MAIT, and it works for us. How is your data laid out?

 

[My Aswer Is This]

I already tried that and no go! But Thanks for your response!

This worked for me.
Looking for 0 in column A

 

[My Aswer Is This]

If your looking for a Vba solution.
Try this:
Looking in Range("A1:A10") For 0

Sub Count_Me()
'Modified  10/6/2018  7:09:44 PM  EDT
ans = Application.WorksheetFunction.CountIf(Range("A1:A10"), 0)
MsgBox ans
End Sub

 

[Ultimate Selector]

Sorry, I had to run out for min. My data is laid out left to right with formatting.

<colgroup><col width="39"></colgroup><tbody>
[TD="class: xl66, width: 39"]
=COUNTIF(k28:t28,0)[/TD]

</tbody>

[TABLE="width: 39"]
<colgroup><col width="39"></colgroup><tbody>[TR]
[TD="class: xl64, width: 39"]
=COUNTIF(k28:t28,0)[/TD]
[/TR]
</tbody>[/TABLE]

 

[Ultimate Selector]

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.

 

[My Aswer Is This]

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

We gave you example. Not knowing the range