SUMIF function with additional requirement to exclude #N/A

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!

when you have two conditions you have to use SUMIFS, not sumif. Hope that helps.

AND, you need to add another criteria, In the sumifs you have the sum range, criteria range one, criteria one, criteria range two and criteria two, etc.

Plus you have to use the same ranges.

Originally Posted by Sambo kid

when you have two conditions you have to use SUMIFS, not sumif. Hope that helps.

Plus you have to use the same ranges.

Thank you Sambo kid but it appears that excel says i have not got enoguh arguments in my formula?

=SUMIFS(C2:C32,"Yes",M2:M29, "<>#N/A")

thank you

I'm guessing but I think this is what you are actually looking for...
=SUMIFS(M2:M32,M2:M32,"<>#N/A",C2:C32,"yes")
I'm guessing that the area you are summing is in M and the are with the yes is in C. This should work for you if that is the case.

Originally Posted by Sambo kid

I'm guessing but I think this is what you are actually looking for...
=SUMIFS(M2:M32,M2:M32,"<>#N/A",C2:C32,"yes")
I'm guessing that the area you are summing is in M and the are with the yes is in C. This should work for you if that is the case.

bingo! was about to share a sheet. thank you!

You're welcome! And thank you for the rep!