I am trying to create a spreadsheet with lists that have different values. I
want to mark a row with an X which will reduce the total of that column
automatically. This spreadsheet is basically an audit sheet. It is being
designed as an audit sheet for employee evaluations.

Example:
___ Red (worth 4 pts)
_X_ Blue (worth 3 pts)
___ Green (worth 2 pts)
_6_ Total out of 9

Any ideas? I tried the IF, Lookup, Count functions with no avail.

Thanks!