Help with formulas

[Lenneahs]

I am trying to count the number of entities that have paid “$0.00” towards a balance they have with us. I’ve tried the counta and the countif formulas putting =0.00 in the quotes but I have been getting 0 as the answer. Does it matter that the 0.00 is the result of a formula and/or some cells in the column are blank?
Please help. Thanks.

[#2]

@Lenneahs 

Blank cells don't matter, but the formulas might not return exactly 0.

Try replacing formulas

=expression

with

=ROUND(expression,2)

Does that solve the problem?

[#3]

Thanks for your response. I understand what you are saying and that could help. Basically, I am trying to get a formula that will count all who have $0.00 in column I- “partial amount paid to date” in the attachment. It should be 12 on the 9/30 worksheet and 41 on the 8/30 worksheet if you count them up the hard way.

[#4]

@Lenneahs 

Use

=COUNTIFS(I2:I199,"<0.01",I2:I199,">-0.01")

[#5]

Thank you so much! It worked!!