Quote Originally Posted by NBVC View Post
Are you getting the Div/0 error? Do you have actual cells that do match? If not, and you want blank returned.. then:

=IF(SUMPRODUCT(--(MOD($A$2:$K$500,1)=MOD(O2,1))),SUMPRODUCT(--(MOD($A$2:$K$500,1)=MOD(O2,1)),$C$2:$M$500)/SUMPRODUCT(--(MOD($A$2:$K$500,1)=MOD(O2,1))),"")

I'm not quite sure. I'm fairly new to excel and I am not positive how to incorporate the formula into my spreadsheet. Any chance you could help me with that? I'd really appreciate it. Sorry to be a pain