How to remove #N/A result from sum/match function?

Hello,

Can somebody help me out with the problem I have? On the attached spreadsheet I have tried SUM function in the column named Next Week. I came back as #N/A because of Match function in the cells it is summing. If anyone knows how to turn this #N/A to 0 in the cells I am summing it would be great because it doesn't want to sume the cells with the real values.

Thank you for reading
Simon

Without looking what you are trying to achieve:

=IF($A36="","",SUM((IF(ISNA(I36),0,I36))+(IF(ISNA(J36),0,J36))+(IF(ISNA(K36),0,K36))))

Use the ISNA() function to trap errors.

Thank you. Works perfectly for me. This is exactly what I wanted to achive.

Thanks once again.
Simon