SUMIF function with additional requirement to exclude #N/A

[rayted]

Hi guys

maybe a quick question but can some help me write a function to exclude #N/A from my sumif function below:

=SUMIF(C2:C32,"Yes",M2:M29, "<>N/A" what am I doing wrong?

thanks!