I have a spreadsheet that I want to use to key answers to a survey.

Here is a sample:
..................................................... 1 2 3
1. Rate the service of the company ... x
2. Rate the friendliness of the comp ..... x
3. Rate the cleanliness of the comp ..... ..... x

After I key in 500 surveys using all the columns up to the end I need to be able to count how many X's are under the 1s, how many x's are under the 2s and how many x's are under the 3's.

Since I am only showing you one survey, try to imagine columns containing 1, 2 and 3 all the way to the right.

I am baffled.

I tried the following to no avail:
=SUM(IF((K43:IV43="1"),1,0))
=SUM(IF((K43:IV43="2"),1,0))
=SUM(IF((K43:IV43="3"),1,0))

Thinking I would key the number instead of an X

And I tried this, but then couldn't figure out how to count all the same numbers at the end:
=IF(K42="X","1",IF(L42="X","2", IF(M42="X","3",0)))

I am a neophyte so any help anyone can give me will be appreciated.

Thank you.