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