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.

=COUNTIF(k28:t28,0)

<colgroup><col width="39"></colgroup><tbody>
</tbody>

=COUNTIF(k28:t28,0)

<colgroup><col width="39"></colgroup><tbody>
</tbody>

 

[Ultimate Selector]

This is my data layout ...

	3	2	1 2	1 2 3	1	1%	1234	5 10	2%	3%
#1								86			#1
#2								98			#2
#3	2			10			15	87		10	#3
#4	1			5			5	85		5	#4
#5							16	93			#5
#6		1	5	5			31	73	5		#6
#7	5	14	64	87			93	11	64	24	#7
#8	2		91	100	20	91	100			10	#8
#9	6			29			55	47		29	#9
#10	5	7	41	65	2	9	86	21	32	24	#10

<tbody>
</tbody>

* 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