Add cells with letter values assigned a number

[muels7]

Hey everyone, hoping someone can help me here.

I have created a sheet that is going to be used to mark various inventory items returned, not returned, or damaged. If they are not returned or damaged, I need to charge the person the value of the items so I am trying to create a final total of amount due for each person. I was going to just use the letters "d" for damaged, "n" for not returned, and "y" for returned. Each column is going to have a different price value however so I can't just assign a value to each letter.

For example, I have tried =Sum(If(A2:A30 = "d" or "n", 380, 0), If(B2:B30 = "d" or "n", 20, 0)). I get an error every time I do this however. The error appears to be related to the "or" . If I run the formula without the "or" it works. I need to run the formula for 2 values though.

What am I doing wrong or is there a better way I could be doing this?

[Pepe Le Mokko]

=380*(countif(A2:A30,"d")+countif(A2:a3,"n"))+20*(countif(B2:B30,"d")+countif(B2:B30,"n"))

(There must be something shorter though)

[AlKey]

maybe this

=380*SUM(COUNTIF(A2:A30,{"d","n"})+20*SUM(COUNTIF(B2:B30,{"d","n"})))