I
am adding up C2:C7, but I want to stay within the same row
when converting the "Y" or "N" to the value I set for it.
In other words this is how I want it to work...

C2 Y (value I set in formula = +1)
C3 3
C4 N (value I set in formula = -2)
C5 10
C6 Y (value I set in formula = +3)
C7 2
C8 17 (Total)

Any Ideas?

Corey