use multiple columns and sum multiple COUNTIFs

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Steve" wrote in message ...
| I'm entering the results of a survey into Excel. The answer to one of the
| questions was a number from 1-6. I entered all the data, then used COUNTIF
| to tell me how many respondents entered 1, how many 2, how many 3, etc.
|
| Now I'm getting the next survey coming back, almost the same results, but
| respondents are allowed to tick multiple boxes. So someone may enter 1 and 4
| and 6 to the same question!
|
| Can I enter something like 1,4,6 in the same column and still get a
| breakdown of how many respondents ticked each number? I don't think COUNTIF
| can handle this.
|
| TIA
|
| Steve
|