COUNTIFS for ranking - cell errors are not transferring as errors

[heathball]

=COUNTIFS($CA:$CA,$CA3,CR:CR,"<"&CR3)+COUNTIFS($CA3:$CA3,$CA3,CR3:CR3,CR3)

with this, which I'm using to rank numbers within a range, it works very well, except for the fact that the errors in column CR are not appearing as errors

Currently they are appearing as numbers (the total number of counts in each range +1)



If there is an error (#value!) in column CR, how can i get it appear as an error in the resulting cell?

thanks in advance

 

[steve the fish]

You could test the cell first.

=IF(ISERROR(CR3),CR3,COUNTIFS($CA:$CA,$CA3,CR:CR,"<"&CR3)+COUNTIFS($CA3:$CA3,$CA3,CR3:CR3,CR3))

 

[heathball]

Thanks Steve, that works great