Help in shortening excel formula

[Juliens]

Hello helpful souls,

I have just signed up here to learn the wonders of Microsoft Excel and a complete total noob. I just want to ask for help in shortening my formula:

=IF(D10="Yes",C10)+IF(D11="Yes",C11)+IF(D12="Yes",C12)+IF(D13="Yes",C13)+IF(D14="Yes",C14)+IF(D15="Yes",C15) and so on...


I know there's something I am missing.

Thank you in advance.

 

[sericom]

=SUMIF(D10:D20,"Yes",C10:C20)