Nope. Didnt work. But thanks for the reply.
Maybe I didnt explain well enough. I'll try again. I am on sheet 1. I need to sum column M on sheet 2, IF the value in column A sheet 2 is equal to the value in cell B3(sheet 1). So the exact formula would be:
=SUMIF(SHEET 2!A5:A2000,B3,SHEET 2!M5:M2000)
BUT, there are errors in column M sheet 2.
Thanks again.
OOPS. Forgot part at the end.
{=SUM(IF(ISNUMBER(data!N$4:N$2000),data!N$4:N$2000)*(data!$A$4:$A$2000=$A5))}
This returns 0. But there should be a number greater than 0.