Formula Error

[Guest]

I’m trying to create a formula and I’m having a little problem getting it to
work correctly.

Here’s 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.

 

[Guest]

=500-SUMIF(G4:G197,"Y",F4:F197), or if you want a negative result (using your
example) =SUMIF(G4:G197,"Y",F4:F197)-500

 

[Guest]

Thank you very that worked perfected your a lifesaver