I am trying to build a sheet that brings certain values to playing card
values. Example: A deck of playing cards, 2's through 6's = +1. 7's, 8's and
9's have 0 value and 10's and Aces (A) have a value of -1.

I have an IF formula so that when any of these cards 2-Ace (A) is inserted
in a cell, then it returns its appropriate value. It looks like this:

=IF(A2=7,"0",IF(A2=9,"0",IF(A2=8,"0",IF(A2=2,"1",I F(A2=3,"1",IF(A2=4,"1",IF(A2=5,"1",IF(A2=A10,"-1"))))))))

Now, in cell K1, I want to sum the row of newly aquired values (either +1,
-1, or a 0) and I can't get it to work. It won't add the row with =sum

Thanks for your expertise,

Robb