sumifs (i think) formula problem

Hi, I'm a real novice when it comes to Excel, so this is possibly an easy formula.

I have 4 columns (D, E, F and G)

The sums applied to Column E and F are dependent on a Yes or No answer to column D.

If D2 is Yes, F2 will need to apply =SUM(E2/1.2) If D2 is No, then F2 will need to be blank.

Also if D2 is Yes, G2 will need to apply =SUM(E2-F2) If D2 is No, then G2 will need to be blank.


I have tried with the SUMIFS function, but can't get it to work.

Help me please.

Thanks Colin, this is an extremely useful forum!

I was so close, lol. Thanks for the answer.