I am trying to run an IF statement in Google Spreadsheet that will, if "Yes" SUM a series of values.

=IF(G3="Yes",=SUM(C3*D3)+(E3*D3))

This works (if I ignore the IF) and just do =SUM(C3*D3)+(E3*D3), so I know my math is correct.

I have read a few different posts that are asking similar questions, but many have "guesses" and are offering different structured formulas, so I'm not really even sure what the proper structure is any more.

Basically, for the nerdy portion of you, the spreadsheet does the following:

If the "killed" column is Yes, I need to calculate the XP of the monsters killed.

Base XP (C3) times Qty (D3), plus Bonus XP (E3) times Qty (D3) and them SUM the value.