How to SUM IF marked cells

[WarrenCarr]

I want to sum if certain cells if the corresponding cell is marked with "Y" and if they are marked with "N" or left blank then subtract the amount in the corresponding cell. I am sure this is not hard to write a formula for but I cant figure out how to do it. Any help would be appreciated!

 

[Fluff]

How about like

=SUMIFS(D:D,C:C,"Y")-SUMIFS(D:D,C:C,"<>Y")

 

[Peter_SSs]

Another possibility

=2*SUMIFS(D:D,C:C,"Y")-SUM(D:D)