rayramirezdvm,

Firstly, not 100% idiot proof but you could count the X's by using e.g. for your C11 =LEN(C11)
It will actually count any characters but you will have to rely on user entry discipline to avoid spaces or maybe use..... =LEN(SUBSTITUTE(C11," ",""))

You could use SUMPRODUCT to compute some of the stats you want but given the variety of stats you mention above I think it would be worth restyling your raw data and then exploring the use of a pivot table.

Below is a link to one of a series of video tutorials (You Tube abounds with such things) that might be worth you watching.

https://www.youtube.com/watch?v=8ffdXfriLPQ
Hope that helps.