Issue with Sumifs Function

Originally Posted by Cutter

You'll get the #VALUE error if the ranges are mismatched.

Show us the formula that is causing the error.

=SUMIFS($K$3:$K$1048576,$N$3:$N$1048576,N3,$B$3:$B$1346,"=No")