countifs with a round

[MetLife]

Hi,

I want to count the times column A is the same as column B, but I want to round to 2 decimal places. Is this possible?

Something like:
=COUNTIFS(Round(AR13:AR30000,2) = Round(AX13:AX30000,2))?

 

[Joe4]

Try this:

=SUMPRODUCT(--(ROUND(AR13:AR30000,2)=ROUND(AX13:AX30000,2)))

 

[MetLife]

Try this:

=SUMPRODUCT(--(ROUND(AR13:AR30000,2)=ROUND(AX13:AX30000,2)))

That basically works, but the problem is some rows have "#NA" errors. Is there any way to zero those values out?

 

[Joe4]

Are those #N/A errors the result of formulas?
If those, the best thing to do would be to change the formulas to handle the #N/A errors directly there.
Can you post the formula that is resulting in the error?

 

[MetLife]

Are those #N/A errors the result of formulas?
If those, the best thing to do would be to change the formulas to handle the #N/A errors directly there.
Can you post the formula that is resulting in the error?

OK yeah that makes the most sense in my situation

 

[Joe4]

OK, great.

Note that you should mark the post with the formula as the solution, as that is the post that answered your original question.
I have updated this for you.