Dealing with single and multiple responses

Hi,

I am trying to find a way to count how many number 1's there are in a column that may contain both single or multiple responses. That is, the 1 could be listed next to other numbers and just separated by a comma.

Meaning that the 1 could be listed next to another number or numbers. The 1 could be in any number of formats:

1,
1, 2,
1, 3,
1, 4,
1, 5,
1, 2, 3,
1, 2, 4,
1, 2, 5,
1, 3, 4,
1, 2, 3, 4,
1, 2, 3, 4, 5, and so on!

To add to my confusion, I need to do this for 19 different questions - so essentially I need a formula that says:

If column A (which is the question number) is 1, and column B contains a 1, or a 1,2, or a 1, 2, 3, etc. then add a 1 to the total in column whatever ...

I have been trying to figure this out for an hour or so already and am not having much success (I am an infrequent excel user, last time I did anything like this was a year ago).

Any assistance would be greatly appreciated.

I have attached some sample data

Thank you very much!