syntax for comparing a rounded number to a rounded list

Can I do this in one step or do I need to break it up?

Please Login or Register  to view this content.

this is the wrong syntax but I hope you can see what I'm trying to do:

Here's the unrounded one that's missing a true case:

Please Login or Register  to view this content.

Hi,

You can do it with SUMPRODUCT:

=SUMPRODUCT(--(ROUND(Intersect!$T$2:$T$11,4)=ROUND(S35,4)))

Regards