Im trying to create a formula and Im having a little problem getting it to
work correctly.

Heres the formula:
=COUNTIF(G4:G197,"Y")+(F4:F197)-500

If anything in G4:G197 = Y
I want it to add the numbers from (F4:F197) and subtract it from 500

G5____F5________G6______F6______G7______F7
Y_____$50________ Y _____$100_______ N _____$200

Total $150-$500 =$350

Any help would be appreciated.