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

 

[mikerickson]

Then you can change the condition to =SIGN(LEN(B1)*LEN(C1))=SIGN(LEN(B1&C1))

 

[Janning197]

Then you can change the condition to =SIGN(LEN(B1)*LEN(C1))=SIGN(LEN(B1&C1))

So, to summarize, what's left I need to do, and am having issue:
1) to keep it clean, and follow suit with the instructions I've given, I need column B to only be "Yes" or blank, column C "No" or blank.
I thought I had the cross validation, it works in B2.(try to enter data in B2), If col B has data, no entry in col C for that row. If col C has data,
no entry in col B for that row.
see the below shared sheet, feel free to do anything with this sheet, it is a test sheet, I have original saved off.

https://docs.google.com/spreadsheets/d/1GdC8XpO2N83aveeJ09t9QamiSa8TGeWJ3IdKvWPoOgk/edit?usp=sharing