In your forumla, $B$3:$B$1346 should be $B$3:$B$1048576 too

else
=SUMIFS($K$3:$K$1346,$N$3:$N$1346,N3,$B$3:$B$1346,"=No") if your range of data is between rows 3-1346