Using SUMIF and IFERROR to sum all $ values and ignore NUM

=IFERROR(SUMIF($B9:$B375,$B12,W9:W375)+SUMIF($B9:$B375,$B13,W9:W375)*W9:W375,0)

I'm trying to add the results of two different columns together. They add successfully, but some times, because the record is not populated, some cells have a NUM error, so I'm trying to tell Excel to add these two columns together, but ignore NUM errors where they occur.

I think I might need to use IF(ISERROR(SUMIF(... instead of IFERROR.

The formula above works but when i a number value is entered in somewhere along cells in Column W, the calculation returns NUM. What am I doing wrong?

Originally Posted by RobertMika

=SUM(IFERROR(IF(($B9:$B375=B12)*($B9:$B375=B13),W9:W375,0),0))
Confirm Control+Shift+enter

That is returning a zero result.

See attached example spreadsheet.

Originally Posted by RobertMika

Apologize shoudl have been
=SUM(IFERROR(IF((C7:C82=C7)+(C7:C82=C8),X7:X82,0),0))

It's working magnificently. Thanks!

Another way without CSE

=SUMPRODUCT(SUMIFS(X7:X82,$C7:$C82,$C7:C8,X7:X82,">0"))