Vote sheet

[Janning197]

Hi,

I have an easy one (not for me). I basically want to make a vote sheet, columns Name (optional), For, Against. (columns A,B,C which can have ..oh? say 1000+ rows) Column D will be empty.
(Frist row, will be header/column names)
Column E will be one cell E2, total FOR's - counts the total number of "X" in Column B rows ,
Column F will be one cell F2, total Against's - counts the total number of "X" in Column C rows ,
and Column G - one row - total votes...is total of E2 + F2
Columns, E,F, and G are protected (I think I got that part)

how can I?
1) Force rows in column B contain "X" or null, (and if the same row has data in column C has an "X", that B row has to be null)
2) Force rows in column C contain "X" or null, (and if the same row has data in column B has an "X", that C row has to be null)
3) Cell E2 counts all the "X's" in Column B
4) Cell F2 counts all the "X's" in Column C
5) Cell G2 is simply E2+F2 (I have this one working)

Below is what I've thrown together so far...the 1's should be X's

http://www.aanning.com/ajissues/VoteSheet/vote1.jpg

Thanks James